any idea?
quick query duplicate records (speicifed fields.value are same) using T-SQL?
depends on how many columns you've got in the table but as an example:
say you have a table called Customer with one column called CustomerID then this simple query will tell you.
SELECT CustomerID, COUNT(*)
FROM Customer
GROUP BY CustomerID
HAVING COUNT(*) > 1
ORDER BY 2 DESC
|||Thanks your reply what i want is
display duplicate records depends on multi-column
regards
|||just add the extra columns in to the SELECT and GROUP BY clauses and it will work for multiple columns.
even better, can u post an example of the data that you are wanting to look for duplicates in?
|||At the same time if you table own identity field you could use another query. Keeping on mind identity value you drop the one own less value.
I'm sorry but I don't have that query
|||Because i want to remove duplicate records,so have to display first i think
I found an article
http://www.sqlservercentral.com/columnists/chawkins/dedupingdatainsqlserver2005.asp
I think it's cool, sharing
