select * from Table as M inner join (select Id,count(1) as Cnt from Table group by a,d,c,d...) as Temp
on M.Id = Temp.Id and Temp.Cnt > 1

------解决方案--------------------
条件 count=(select count(id) from 表)>1的

------解决方案--------------------
having 应该要用到这个

------解决方案--------------------
group by ***having count（。）>1

------解决方案--------------------
select col1,col2... from t group by .... having count(你的列）>1