write a query to delete similar records in particular
fields(columns) in different tables
Answer Posted / satyam kumar
Hi,
I have manipulated Khandu Shinde answer because it will
delete complete row.
delete from emp where rowid not in ( select max(rowid) from
emp group by empno having count(redundantcolumnName) > 1)
Note: work only with Oracle.
Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
How can one get sql*loader to commit only at the end of the load file? : aql loader
What is pl sql script?
How do you create a db file?
What are sql queries used for?
What is full join in sql?
What is mutating sql table?
what is the difference between sql and t-sql? : Transact sql
Why join is faster than subquery?
What are basic techniques of indexing?
What is the difference between python and sql?
Explain what is table in a database?
How do I run pl sql in sql developer?
What is the plv (pl/vision) package offers?
what is top in tsql? : Transact sql
discuss about myisam key cache. : Sql dba