sql查询表中重复数据个数

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

萌橙你瞅啥？

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/daimaxuejia/p/6689713.html