Hi All, I want to display all duplicate records in the table. My query has t

Hi All,

I want to display all duplicate records in the table. My
query has to fetch all the records which are duplicate(First
Name or Last Name). Also I want the ability to also pull
names where there might be a middle initial placed in the
end of the first name field, (i.e., "Maria Z. " vs. "Maria")
as well.

Please guide me to find this.

Table:

ID FirstName LastName

1 Zach H Hoffman

2 Zach Hoffman

3 Troy Hoffman

4 Shawn Livermore

5 Prem S

6 Jony Hoffman H

7 Zach Modan

I need the query to filter.........

ID FirstName LastName

1 Zach H Hoffman

2 Zach Hoffman

3 Troy Hoffman

6 Jony Hoffman H

7 Zach Modan

I hope this example will give you clear idea.....

Thanks in Advance

Prem

Question Posted / prem

2 Answers
4668 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi All, I want to display all duplicate records in the table. My query has to fetch all the reco..

Answer / eralper

Hello Prem,
Please check the forum post
http://www.kodyaz.com/forums/thread/21123.aspx for solution
of your question. I see that you have asked this question
on several forums. That is a good idea to find an answer :)

Is This Answer Correct ?

1 Yes

0 No

Hi All, I want to display all duplicate records in the table. My query has to fetch all the reco..

Answer / vamsi

select id,Lastname, firstname from record where FirstName like 'Hoffman%' or LastName='Zach'

Is This Answer Correct ?

0 Yes

0 No

Post New Answer