Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 4489 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
Is sql server is free?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
How do I find the port number for sql server?
What does sql server mean?
What is compression - row-level and page-level compression?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Explain what are commit and rollback in sql?
What are the 2 types of classifications of constraints in the sql server?
How to fetch the next row from a cursor with a "fetch" statement?
What are indexes in ms sql server?
What are sql servers used for?
What is extended stored procedures?
What is a hint?
What is a print index?
How to manipulate data from one table to another table ?
