select * from [表A] where id in (select id from [表A] group by id having count(id) >1 )
select
*
from
[表A]
where
id
in
(
group
by
having
count
(id) >1 )