Sql Code Masterz

Find and Delete duplicate records Find Duplicate Records using SQL        SELECT name, COUNT(name) AS namecount        FROM tbl_content        GROUP BY name        HAVING ( COUNT(name) > 1)  Delete Duplicate Records using SQL        delete T1 from tbl_content T1, tbl_content T2 where T1.name = T2.name and T1.id > T2.id  Delete Duplicate Records using Access       delete from       MyTable       where uniqueField not in       (select min(uniqueField) from       MyTable T2       where T2.dupField=MyTable.dupField)