删除tTest表里字段col1值相同的纪录:[@more@]
■首先通过如下的SQL查询重复的纪录
SQL>SELECT * FROM tTest t1 WHERE
rowid=(SELECT MIN(rowid) FROM tTest t2
WHERE t1.col1=t2.col1
HAVING COUNT(*)>1);
■确认无误后,删除这些重复的纪录。
SQL>DELETE FROM tTest t1 WHERE
rowid>(SELECT MIN(rowid) FROM tTest t2
WHERE t1.col1=t2.col1);
■确认重复纪录是否删除:
SQL>SELECT * FROM tTest t1 WHERE
rowid=(SELECT MIN(rowid) FROM tTest t2
WHERE t1.col1=t2.col1
HAVING COUNT(*)>1);
■如果没有记录返回,则重复纪录被删除。
SQL>COMMIT;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/174388/viewspace-913203/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/174388/viewspace-913203/