Hello Prem, Please check the forum post http://www.kodyaz.com/forums/thr

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 / eralper

2 Answers
4507 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Write a code to select distinct records without using the DISTINCT keyword.

1115

How do I shrink an ldf file?

980

What is report server project?

147

Tell me what are cursors and when they are useful?

956

What is clustered vs nonclustered index?

948

How to connect ms access to sql servers through odbc?

1030

What is the cpu pressure?

1043

How to make remote connection in database?

1008

What is implicit cursors?

1086

What is sub-query in sql server?

1205

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1139

What is difference between index and primary key?

1100

What are functions in the sql server?

1221

What are recommended options to be used while using db mirroring? : sql server database administration

1160

Explain transaction isolation levels in sql server?

1119