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 are joins in sql and what are the different types of joins?

1059

---

What is the index requirement in SQL Azure?

98

---

What does <> symbol mean?

1026

---

Explain about builtinadministrator?

1114

---

What protocol does sql server use?

986

---

What is difference between rollback immediate and with no_wait during alter database?

1131

---

How many types of triggers in sql server?

1089

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1688

---

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

1075

---

Describe the functionalities that views support.

1145

---

Define candidate key, alternate key, and composite key.

967

---

Is mysql better than sql server?

1106

---

What are the types of subscriptions in SQL Server replication?

1103

---

What are statistics?

1050

---

How much space does sql server 2016 take?

1033

---