Answer Posted / prem

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

What is a filestream?

985

---

What is lookup override?

1019

---

what is a check constraint?

1091

---

How to turn off warning messages during php execution?

1035

---

What is a result set object returned by odbc_exec()?

1017

---

Explain powershell included in sql server 2008?

1045

---

Explain about remote stored procedure?

1002

---

List the different index configurations possible for a table?

930

---

What is the ‘fillfactor’?

964

---

Do you know what is blocking?

944

---

Mention what are the core components of ssrs?

323

---

How to add an address record into adventureworkslt?

984

---

What is function of ROLLUP ?

1078

---

How to assign new column names in a view?

911

---

What is difference between delete & truncate commands?

1071

---