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

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

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

Thank u
I got the solution.

Please marked this post as solved, thank you.