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
Explain oracle 12c new features for developers?
How to assign a table row to a record variable?
What is the difference between view and materialized view in Oracle?
What are a query and state the different types of queries and their uses?
What is the data pump export utility?
What is the purpose of save points in oracle database?
Explain an integrity constrains?
Is there an oracle sql query that aggregates multiple rows into one row?
What is a named program unit?
How to create a stored procedure in oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
What are the differences between interval year to month and interval day to second?
How to create additional tablespaces for an new database?
What are the limitations of check constraint?
How to get last row id?