查找SQL表中多余的重复记录(多个字段),in前面只能跟一个字段吗?

2025-03-23 22:07:55
推荐回答(1个)
回答1:

select * form vitae
where peopleld in (select peopleID from vitae group by peopleId,seq having count(*) > 1) and seq in (select seq from vitae group by peopleId,seq having count(*) > 1)