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
- 4392 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
What are the restraints imposed on the table design by a merge replication?
How to insert multiple rows with a subquery?
What is user defined stored procedures?
What is a cube? : sql server analysis services, ssas
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is the purpose of sql profiler in sql server? : sql server database administration
What are the advantages of policy management?
Explain some stored procedure creating best practices or guidelines?
How can we migrate from SQL server to SQL Azure?
What is index fragmentation in ms sql server?
How do I connect to sql server database?
How to add an address record into adventureworkslt?
What is log ldf?
What is purpose of normalization?
Differentiate between mongodb vs. Sql server?
