sql查询表中重复数据个数

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

posted @ 2017-04-10 16:42  萌橙  阅读(16125)  评论(0)  编辑  收藏  举报