【不断补充中】sql总结

id字段重复值

select id from table group by id having count(id) >1

不连续id，oracle, 先构造顺序的，然后MINUS本身

select rownum from all_objects where rownum < = (select max(id) from table) minus select id from table

查询重复数据，多个字段条件,（同一个a,b值,下有多个同名的c）

select a,b,c from table group by a,b,c having count(c)>1