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
What is rowid and rownum in oracle?
Explain the use of record length option in exp command.
How do I start tns listener?
What is the use of oracle?
What do you mean by merge in oracle and how can you merge two tables?
Please explain drop constraint oracle?
Give the various exception types.
How do I manually create a database in oracle?
How to convert a date to char in oracle? Give one example.
how to clone 9i Database on to 10g Database.
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
Explain a synonym?
What is the difference between postgresql and oracle?
What is BBED in Oracle?
What is a partition in oracle?