.Net ramblings
# Tuesday, 26 April 2005
An SQL Query to find duplicate values
SELECT <KEY_COLUMN>, COUNT(*)
FROM <TABLE> GROUP BY <KEY_COLUMN> HAVING COUNT(*) > 1

Tuesday, 26 April 2005 17:00:35 (GMT Daylight Time, UTC+01:00)  #    Comments [0]  Database