 |  |  |  |  |  |  |  |
Quick Search(Finding Duplicate Records)
Please support our Java advertiser: Programming Forums - DaniWeb Sister Site
 |
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,718
Reputation: 
Solved Threads: 230
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
Views: 1158 | Replies: 6
| Thread Tools | Search this Thread |
Latest Java Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Java
6 android api apple applet application arguments array arrays automation binary bluetooth bold byte c++ chat class classes client code component coordinates database datagram doctype draw eclipse educational error event exception file fractal froglogic game givemetehcodez graphics gui helpwithhomework html ide ideas image ingres input integer internet intersect ip j2me java javaexcel javaprojects jmf jni jpanel jtextarea julia linux list loop map method methods mobile netbeans newbie nextline number object oracle pong print problem program programming project recursion recursive scanner screen sell server set size sms socket sort sql string swing test threads time transfer tree user web websites windows
