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
What are the parameter modes supported by pl/sql?
how to load data files into tables with 'mysqlimport'? : Sql dba
What's the difference between a primary key and a clustered index?
What is the maximum rows in csv?
What is latest version of sql?
What is 19 null in sql?
Can dml statements be used in pl/sql?
Explain unique key in sql.
How do you write a complex sql query?
How to write a query to show the details of a student from students table whose
how to select first 5 records from a table? : Sql dba
What is the advantage of index in sql?
explain advantages of myisam over innodb? : Sql dba
What does t sql mean?
Why is partition used in sql?