 |  |  |  |  |  |  |  |
Quick Search(Finding Duplicate Records)
 |
In Project Contains huge data. In a table nearly 1.5 lac records are there.Those records Contains First Name,LastName,and Father Name.
My problem is to find duplicate Records based on the names. Moreover i want to search these records Quickly.
any solution is there for quick accessing
Can anybody give the solution for this problem
My problem is to find duplicate Records based on the names. Moreover i want to search these records Quickly.
any solution is there for quick accessing
Can anybody give the solution for this problem
•
•
Join Date: Dec 2007
Posts: 1,658
Reputation: 
Solved Threads: 224
When you say table you mean database table?
If yes do an order by and read the data using ResultSet. Then check for duplicates
If yes do an order by and read the data using ResultSet. Then check for duplicates
Check out my New Bike at my Public Profile at the "About Me" tab
•
•
Join Date: Nov 2008
Posts: 823
Reputation:
Solved Threads: 73
Practically a Posting Shark
Duplicates meaning, the entire name should be identical or just any of the first name, last name etc ?
Check "select firstname, count(first name) from tablename having count(firstname) > 1" something like this.
Check "select firstname, count(first name) from tablename having count(firstname) > 1" something like this.
Get up every morning and take a look at the Forbes' list of richest people. If your name doesn't appear.... GET TO WORK !!!
•
•
•
•
Originally Posted by verruckt24 
Duplicates meaning, the entire name should be identical or just any of the first name, last name etc ?
Check "select firstname, count(first name) from tablename having count(firstname) > 1" something like this.
Any Of the names that is, Following are the records
House_no FirstName LastName FatherF_NM Father_L_NM
-------------------------------------------------------------------------------------
1-1/A Ajay Kumar Surender Verma
1-22/A Ajay Surender
1-33 Ajay Kumar SurenderVerma
I want to find out all these records
•
•
Join Date: Nov 2008
Posts: 823
Reputation:
Solved Threads: 73
Practically a Posting Shark
Then the query given by me should work with modifications wherever you want to have them.
Get up every morning and take a look at the Forbes' list of richest people. If your name doesn't appear.... GET TO WORK !!!
|
Other Threads in the Java Forum
- Previous Thread: Java and Web Services
- Next Thread: Get Parameter value
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Java Posts
- Today's Posts
- Unanswered Threads
911 actionlistener addball addressbook android api append applet application array arrays automation binary bluetooth button character chat class client code component consumer css csv database desktop eclipse ee error fractal ftp game givemetehcodez graphics gui html ide image integer j2me japplet java javaarraylist javac javaee javaprojects jni jpanel julia jvm linked linux list loan mac map method methods mobile netbeans newbie objects online oriented output panel phone printf problem program programming project projects properties recursion replaydirector reporting researchinmotion rotatetext rsa scanner se server service set sms software sort sql string swing test threads time transfer tree ubuntu update windows working
