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
- 4662 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
List out the different types of locks available in sql server?
What is subquery? Explain the properties of a subquery?
What is temporary table in sql server? Why we use temp table?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What are different types of constraints?
What is normalization and what are the advantages of it?
What is self contained sub query?
what is spatial nonclustered index
Can we do dml on views?
How to enter binary string literals in ms sql server?
Why we use the openxml clause?
How can you append an identity column to a temporary table?
Disadvantages of the indexes?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Is it possible to have clustered index on separate drive from original table location?
