oracle查询字段重复数据

select card_no,count(*)    from     GM_PPU_RESIDENT_NORBASE    where  

group by card_no having count(*) > 1