假设表名table,关键字id select id from table group by id having count(*)>1;
假设表A,包含字段field1,field2,field3select * from (select row_number() over(partition by field1,field2,field3 order by field1,field2,field3) as rn,a.* from a) where rn>1 )
select * from where id in (select id from (select 所有字段 group by 所有字段 having count(*)>1))
select id from table group by id having count(*)>1;
)