Tuesday, April 20, 2010

Identify duplicate values in Tables

SELECT Column_Name, COUNT(*) TotalCountFROM Table_NameGROUP BY Column_NameHAVING COUNT(*) > 1ORDER BY COUNT(*) DESC