1、目的:查询MySQL数据表中,重复记录的值
2、示例:
3、代码:
select serial_num,count(*) as count FROM card_ticket GROUP BY serial_num HAVING count >1
4、结果: