Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in particular
fields(columns) in different tables
- 6 Answers
- 13661 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
Can we enter data in a table in design view?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
How does a self join work?
What are the advantages of indexing?
explain advantages of myisam over innodb? : Sql dba
What is sqlca in powerbuilder?
What is database sql?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What are the key differences between SQL and PL SQL?
What is a unique key and primary key and foreign key?
What is trigger in sql? Explain
How to call a javascript function from pl sql?
What is sql procedures and functions?
I need a function for a train ticket reservation please answer it thanks in advance
Explain autonomous transaction.
