how to delete all duplicate records from a table using
subquery?
Answer Posted / sunil
delete emp where empno not in(select distinct empno from emp);
For example we have duplicates in empno column then write
query like above...whatever column u want u can write..
Is This Answer Correct ? | 0 Yes | 11 No |
Post New Answer View All Answers
How to define a specific record type?
How to calculate date and time differences in oracle?
How to add another datafile to a tablespace?
How to drop an index in oracle?
Difference between inner join vs where ?
How to Truncate Table in Oracle
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What are the uses of linked server and explain it in detail?
Calculate difference between 2 date / times in oracle sql?
What is where clause in oracle?
What is hash cluster in oracle?
What are the data types in oracle?
What happens to the current transaction if the session is killed?
How to convert characters to dates in oracle?
How to delete all rows a table in oracle?