how to select only dupliate record from a table??

SELECT * FROM emp a
WHERE rowid = (SELECT max(rowid) FROM emp
WHERE empno = a.empno 
GROUP BY empno
HAVING count(*) >1)


Here is an example on the world most popular table EMP. Try it.