查询pat_card表中pat_card_no出现次数超过1的数据:
select * from pat_card where pat_card_no in (select pat_card_no from pat_card group by pat_card_no having count(pat_card_no)>1)
查询pat_card表中pat_card_no出现次数超过1的数据:
select * from pat_card where pat_card_no in (select pat_card_no from pat_card group by pat_card_no having count(pat_card_no)>1)