查重语句
select * from table where id in (
select id from table
group by id
having count(id ) > 1
)
;
部分项目会存在一个id固定几条记录,可以使用此方法查询记录数不足/丢记录的ID:
select * from table where id in (
select id from table
group by id
having count(id ) < n
)
;
查重语句
select * from table where id in (
select id from table
group by id
having count(id ) > 1
)
;
部分项目会存在一个id固定几条记录,可以使用此方法查询记录数不足/丢记录的ID:
select * from table where id in (
select id from table
group by id
having count(id ) < n
)
;