查询一个表中的重复数据

select train_code,count(1) from tb_ask_trainbodyroadtrain group by train_code having count(1) >1

posted @ 2017-05-09 16:39  萌橙  阅读(181)  评论(0)  编辑  收藏  举报