【MySQL】MySQL中查询出数据表中存在重复的值list

1、目的:查询MySQL数据表中,重复记录的值

2、示例:

 

3、代码:

select serial_num,count(*) as count 
FROM card_ticket 
GROUP BY serial_num
HAVING count >1

 4、结果:

 

posted @ 2018-10-30 15:46  PHP急先锋  阅读(976)  评论(0编辑  收藏  举报