Return to Snippet

Revision: 29923
at August 5, 2010 05:39 by lance


Initial Code
SELECT COUNT(TABLE_ID), TABLE_ID 
FROM TABLE
group by TABLE_ID
having count(TABLE_ID)>1
order by TABLE_ID

Initial URL


Initial Description


Initial Title
Find duplicate records in table

Initial Tags


Initial Language
SQL