How to Find the Number of Repeating Values in a Table

How to Find the Number of Repeating Values in a Table

 SELECT EmpNo, RepeatNo=count(*)  
 FROM Employee  
 GROUP BY EmpNo  
 HAVING count(*) > 1  
 ORDER BY RepeatNo DESC