select * from list where callnumber in (select callnumber from list where group by callnumber having(count(*))>1) order by callnumber
select * from list where callnumber in (select callnumber from list where group by callnumber having(count(*))>1) order by callnumber
下一篇:SQL查询语句精华使用简要
查询重复记录的SQL语句
举报文章
请选择举报类型
补充说明
0/200
上传截图
格式支持JPEG/PNG/JPG,图片不超过1.9M