查询数据库中重复记录的方法
时间:2022-03-10 18:05
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)
查询数据库中重复记录的方法,布布扣,bubuko.com