Omprakash-Share
Tuesday, April 20, 2010
Identify duplicate values in Tables
SELECT Column_Name, COUNT(*) TotalCountFROM Table_NameGROUP BY Column_NameHAVING COUNT(*) > 1ORDER BY COUNT(*) DESC
No comments:
Post a Comment
Newer Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment