Remove Duplicate Rows SQL

select * from c73ftp/qo777 a where exists (
select 'a' from c73ftp/qo777 b where
b.f1=a.f1 and b.f2=a.f2 group by b.f1,b.f2
having a.id