当然,如果已经插入了若干条重复数据,则可以这么删除:1 2 3 4 5 6 7 8 9 10 DELETE FROM a USING questions AS a,(SELECT*FROM questions GROUP BY question,correctAnswer HAVING COUNT(*)>1)AS b WHERE a.question=b.question AND a....
例表如下:表名:MYTEST TID COL1 COL2 COL3 1 1 A A2 1 A A3 2 A A4 2 B A5 3 B B6 3 B B7 4 C B8 4 C B9 ...7 4 C C则结果为:COL1 COL2 COUNT 1 A 1 2 A 1 2 B 1 3 B 1 4 C 2即按COL1,COL2分组后COL1,COL2的内容和每组中COL3不重复的记录数