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
- 4603 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
Explain error handling in ssis?
What is row_number()?
How can i Relate Tables in SSIS
how would you improve etl (extract, transform, load) throughput?
what is denormalization and when would you go for it? : Sql server database administration
What do you understand by the denormalisation?
Using the customer, and order table in northwind database, please write a query to produce xml?
What is 2nf example?
Does a full backup include transaction log?
What is ssl in sql server?
What is the dbcc command and why is it used?
In what three ways is the return statement used in a stored procedure?
Which is faster statement or preparedstatement?
Explain about Normalization?
how we use window authentication connection with sql server.?
