- 博客(0)
- 资源 (1)
空空如也
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)
2012-11-08
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人