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
Why primary key is required?
What is db journal file?
Explain exception handling in pl/sql?
What is the use of function "module procedure" in pl/sql?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is an inner join sql?
What is t sql used for?
How many sectors are in a partition?
How are functions and procedures called in PL/SQL?
What is a full join sql?
What is cursor in pl sql with examples?
Which one is faster ienumerable or iqueryable?
What is raid? How does it help storage of databases?
What is sql resultset?
what happens if null values are involved in expressions? : Sql dba