Quick Search(Finding Duplicate Records)

[tulsi_apr03]

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

[javaAddict]

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

[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.

[tulsi_apr03]

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

[verruckt24]

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

[tulsi_apr03]

Thank u
I got the solution.

[PoovenM]

Please marked this post as solved, thank you.