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
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
转载于:https://www.cnblogs.com/hanwenhua/articles/2949628.html