sql面试的
来源:互联网 发布:nba2k16三井寿捏脸数据 编辑:程序博客网 时间:2024/06/06 21:43
1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断
select * from people
where peopleId in (select peopleId from people group by peopleId having count
(peopleId) > 1)
2、删除表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断,只留有rowid最小的记录
delete from people
where peopleId in (select peopleId from people group by peopleId having count
(peopleId) > 1)
and rowid not in (select min(rowid) from people group by peopleId having count(peopleId
)>1)
3、查找表中多余的重复记录(多个字段)
select * from vitae a
where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having
count(*) > 1)
4、删除表中多余的重复记录(多个字段),只留有rowid最小的记录
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)
5、查找表中多余的重复记录(多个字段),不包含rowid最小的记录
select * 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)
select * from people
where peopleId in (select peopleId from people group by peopleId having count
(peopleId) > 1)
2、删除表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断,只留有rowid最小的记录
delete from people
where peopleId in (select peopleId from people group by peopleId having count
(peopleId) > 1)
and rowid not in (select min(rowid) from people group by peopleId having count(peopleId
)>1)
3、查找表中多余的重复记录(多个字段)
select * from vitae a
where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having
count(*) > 1)
4、删除表中多余的重复记录(多个字段),只留有rowid最小的记录
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)
5、查找表中多余的重复记录(多个字段),不包含rowid最小的记录
select * 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)
- 常用的sql面试
- sql面试的
- 面试的一条sql问题
- 常见的SQL面试题目
- SQL面试
- sql面试
- 面试sql
- sql 面试
- sql面试
- sql面试
- SQL面试
- sql面试
- sql面试
- sql面试
- SQL面试
- SQL面试
- SQL面试
- 面试的时一道sql的解答
- 在ubuntu上eclisp安装android的编程环境
- 在网吧下书无聊说几句话
- “源代码与原始版本不同”问题
- IE8 修改查看源代码的工具
- 拿什么来拯救你,我的c++?
- sql面试的
- Google Web 字体 API 访谈
- J2EE开发游戏介绍(乐成---张老师(www.ldci.com.cn) --学习笔记
- 一位软件工程师的6年总结
- AXIS2 访问控制的 BASIC认证说明
- USB枚举周详过程剖析(转)
- 收缩数据库会导致严重的索引碎片
- 获取TreeView中被checkbox选中的值
- 如何终止线程的运行(C/C++)