how to delete all duplicate records from a table using
subquery?
Answer Posted / dharmendra
delete from emp e1 where rowid >(select min(rowid) from emp
e2 where e1.empid=e2.empid)
| Is This Answer Correct ? | 12 Yes | 5 No |
Post New Answer View All Answers
What is oracle instant client?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How to invoke the data pump export utility?
How do I uninstall oracle client from windows?
how to join query for one source type is oracle another source type is sql server ?
Explain about your project and its relation to the current job position you are applying to?
How to see free space of each tablespace?
ABOUT IDENTITY?
How to select some columns from a table in oracle?
How is it different from a normal table?
How to estimate disk space needed for an export job?
how may join possible between (requisition with purchase order)
How to handle a single quote in oracle sql?
How to find out what oracle odbc drivers are installed?
How to list all user accounts in oracle?