sql查询表中重复数据个数

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

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