【文件属性】：
文件名称：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)