oracle 查找字段值相同的记录

select * from account wnhere idcardno in(

select idcardno from account

group by idcardno

having count(*)>1)