write a query to delete similar records in different tables
with same structure
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 primary key in db?
What is composite data type in pl sql?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What are the basic techniques of indexing?
What is data type in database?
What is the difference between functions, procedures, and packages in pl/sql?
What is difference between inner join and cross join?
What is nvarchar max in sql?
What are the sql aggregate functions?
How to create your own reports in sql developer?
Which normal form is best?
Why do we use function in pl sql?
What are different types of triggers?
What are the types of records?
What is sql performance tuning?