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
- 9472 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 is a database transaction? : Sql dba
Why is pl sql used?
How to check if a column is nullable before setting to nullable?
What jobs use sql?
What is meant by user defined function?
When to use inner join and left join?
Write a sql select query that only returns each name only once from a table?
What is parallel hint?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What is sql procedures and functions?
How do you delete data from a table?
explain access control lists. : Sql dba
What are the datatypes available in pl/sql ?
Can we use two order by clause in query?
How many sectors are in a partition?
