- 博客(2)
- 资源 (3)
- 收藏
- 关注
转载 SQL重复记录查询(转载)
1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断 select * from people where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1) 例二: select * from testtable wh
2012-03-29 15:46:49 352
原创 sql查询重复记录、删除重复记录方法大全
多字段删除 delete from dir_act where id in( select max(id) from dir_act group by dirid,actid,item_name having count(*)>1 ) 这个没有测试 select id from dir_act where id not in( select min(id) from dir_act
2012-03-06 13:38:37 304
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人