常用sql语句总结3（查询sort值重复的数据）

select *from BaseInfo_Dictionary where ParentID=1 and Sort in (

select Sort From BaseInfo_Dictionary where ParentID=1  group by Sort having COUNT(Sort) >1)

order by Sort