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

Re: Quick Search(Finding Duplicate Records)
 

When you say table you mean database table?
If yes do an order by and read the data using ResultSet. Then check for duplicates

Re: Quick Search(Finding Duplicate Records)
 

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.

Re: Quick Search(Finding Duplicate Records)
 

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

Re: Quick Search(Finding Duplicate Records)
 

Then the query given by me should work with modifications wherever you want to have them.

Re: Quick Search(Finding Duplicate Records)
 

Thank u
I got the solution.

Re: Quick Search(Finding Duplicate Records)
 

Please marked this post as solved, thank you.