ОБНОВЛЕНИЕ столбца таблицы postgres

Использование rowid -

delete from emp
 where rowid not in
 (select max(rowid) from emp group by empno);

Использование self join -

delete from emp e1
 where rowid not in
 (select max(rowid) from emp e2
 where e1.empno = e2.empno );