how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used
- 11 Answers
- 15833 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / mkumar.it
delete <table_name> where rowid not in (select min(rowid)
from <table_name> group by <dup_rec_col>)
max(rowid) can also be used provided you have to retain the
latest value other wise min(rowid) is fine.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
what are different types of keys in sql?
Can we perform dml on view?
What is clustered index sql?
How do I run pl sql in sql developer?
Does oracle use sql?
Which command is used to delete a trigger?
How do I write a sql query in pgadmin 4?
Are there any features that are decommissioned in 11g that are not present in 11g?
Which constraints we can use while creating database in sql?
What is the difference between subquery and correlated query?
How to display the records between two range in Oracle SQL Plus?
Is sql open source?
Can pl sql procedure have a return statement?
What is the purpose of a secondary key?
What is string data type in sql?
