I cannot find an easy way to DELETE items which are > 1 time in my table (i am working with MS SQL 2000)
Code:
id serial isOk
-------------------
2 AAA 1
3 BBB 0
5 dfds 0
6 CCC 1
7 fdfd 0
8 AAA 0
9 CCC 0
I want to DELETE each Row IN
Code:
SELECT doublons.serial, Count(doublons.serial) AS 2Times
FROM doublons
GROUP BY doublons.serial
HAVING Count(doublons.serial)>1
and WHERE isOK = 0
in my exemple , after deleting, my table must look like
Code:
id serial isOk
-------------------
8 AAA 1
9 CCC 1
3 BBB 0
5 dfds 0
7 fdfd 0
thank you for helping