0

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

4
Contributors
6
Replies
7
Views
8 Years
Discussion Span
Last Post by PoovenM
0

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

0

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.

0

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

This article has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.