 |  |  |  |  |  |  |  |
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,625
Reputation: 
Solved Threads: 221
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: 822
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: 822
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
android api applet application apps array arrays automation awt bidirectional binary birt bluetooth businessintelligence busy_handler(null) card class classes client code collision columns component constructor crashcourse database designadrawingapplicationusingjavajslider draw eclipse error errors eventlistener exception expand fractal free game givemetehcodez graphics gui guidancer html ide image inetaddress integer intellij j2me java javadoc javafx javamicroeditionuseofmotionsensor javaprojects jme jni jpanel jtree julia linux list loop machine map method methods migrate mobile mobiledevelopmentcreatejar myaggfun netbeans newbie oracle plazmic print problem program project radio recursion scanner server set sharepoint smart sms smsspam sort sortedmaps sql string subclass support swing textfield threads tree unlimited utility webservices windows
