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 factless fact table? : sql server analysis services, ssas

1035

---

What is Federation Root Database?

104

---

What is the sql server agent?

1093

---

What are the disadvantages of merge replication?

1424

---

What is the significance of null value and why should we avoid permitting null values?

989

---

how would you improve etl (extract, transform, load) throughput?

1029

---

How does a profiler work?

936

---

What are the different types of sql server replication? : sql server replication

1277

---

What are scalar functions in sql?

1149

---

Explain what are the authentication modes in sql server?

1022

---

Why do we use functions?

918

---

How to disconnect from a sql server using mssql_close()?

1112

---

How can we check the sql server version?

1073

---

Tell me what is fill factor?

964

---

What are the rendering extensions of ssrs?

157

---