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 3643
What are the mathematical functions supported by sql server 2005?
How to change the data type of an existing column with "alter table" statements in ms sql server?
What are the different normalization forms?
what is a correlated sub-query? : Sql server database administration
What is the difference between clustered index and primary key?
What is row_number()?
Where sql server usernames and passwords are stored in a sql server?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
How do I get to sql server configuration manager?
Indexes are updated automatically is the full-text index also updated automatically?
What is a cache in ssrs?
Is mysql the same as sql server?
How many full-text indexes can a table have?
what is a transaction and what are acid properties? : Sql server database administration
What is merge?