write a query to delete similar records in particular
fields(columns) in different tables
- 6 Answers
- 12725 Views
- TCS, I also Faced
- E-Mail Answers
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
explain advantages of innodb over myisam. : Sql dba
How to rename a column in the output of sql query?
What are types of joins?
What is hibernate and its relation to sql?
Which command is used to delete a trigger?
What is database sql?
What are some emotional triggers?
How do you exit in sql?
What is sap sql anywhere?
How many unique keys can a table have?
Why is %isopen always false for an implicit cursor?
Why plvtab is considered as the easiest way to access the pl/sql table?
How can I change database name in sql?
What is varchar used for?
What is application trigger?
