Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in different tables
with same structure
- 4 Answers
- 9447 Views
- I also Faced
- E-Mail Answers
Answer Posted / senthil
This done by Co-related sub-query:- based upon ROWID
uniqness this deletes the duplicate rows.
Delete from emp x where ROWID != (Select MIN(ROWID) from
emp y where y.empno = x.empno);
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
How to use transactions efficiently : transact sql
What is difference between function and trigger?
What are triggers and its uses?
What is the default isolation level in sql server? : Transact sql
What is row_number () in sql?
What is scalar data type in pl sql?
What is full join in sql?
Can we use pl sql in sql server?
How to read/write files from pl/sql?
What are pl/sql cursor exceptions?
How to combine two stored procedures in sql?
what is index? : Sql dba
What is sql keyword?
Do stored procedures prevent sql injection?
What is primary key and foreign key?
