Delete from emp e

  where e.rowid >

   (select min(f.rowid) from emp f

    4 where f.empno=e.empno);