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
- 9576 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
What are the packages in pl sql?
What is server name sql?
Is like operator in sql case sensitive?
What are the different dcl commands in sql?
How do I find sql profiler?
what is auto increment? : Sql dba
Which is faster subquery or join?
How can you tell the difference between an index and a view?
How do I view a sql database?
What are sql data types?
What is sql and its types?
What are the two parts of design view?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is %type in sql?
How to avoid duplicate records in a query?
