delete from scott.emp where empno in(select empno from scott.empgroup by empnohaving (count(empno)>1))but the query will delete all duplicate entries in a table with out keeping one copyAs per my knowledge,There is no option to delete duplicate rows w…
more »
12:12:03 am, by 
XML Feeds