文件名称：SQL删除重复行
文件大小：29KB
文件格式：DOC
更新时间：2015-11-29 03:19:20
SQL 重复行
筛选重复行，删除重复行 使用游标来实现。 delete from vitae a where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1) and rowid not in (select min(rowid) from vitae group by peopleId,seq having count(*)>1)