求一条SQL语句，谢谢！

Question

select yg_no,id_no from t_1 where id_no in (select id_no from t_1 group by id_no having count(id_no)>1)

Answer 1

select * from t
where id_no in(
select id_no from t
group by id_no
having count(*)>1)

Answer 2

select * from t
where id_no in(
select id_no from t
group by id_no
having count(*)>1)

Answer 3

select * from 表 a where (select count(*) from 表 b where a.idno=b.idno)>1

Answer 4

select * from 表 where 列 in (select 列 form 表 group by 列 having count (*)>1 )