How to get duplicate rows from the table ?

Select empno, count (*) from EMP group by empno having count (*)>1;