select id,Lastname, firstname from record where FirstName like 'Hoffma

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

2 Answers
4397 Views
I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

What do you mean by sql server 2005 express management tools?

1253

How the authentication mode can be changed?

1078

Sql server reporting services vs. Crystal reports.

118

How to create new tables with "select ... Into" statements in ms sql server?

932

How you trouble shoot when any job fails

1896

Explain what is the difference between a local and a global temporary table?

938

What is report server project?

135

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

1072

Can coalesce return null?

948

How to select all columns of all rows from a table with a select statement in ms sql server?

1046

Can we use custom code in ssrs?

1060

How to select true false based on column value in sql server?

956

Explain how to use linked server?

928

What is the data type of time?

912

What are commit and rollback in sql?

1053