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
- 9235 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 rtm stands for?
What is the command used to fetch the first 5 characters of a string?
What is difference between my sql and sql?
how to show all tables with 'mysql'? : Sql dba
Why are cursors used?
What is the maximum number of triggers, you can apply on a single table?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is sql data?
Is primary key a clustered index?
what is a unique key ? : Sql dba
What are the different datatypes available in PL/SQL?
What are the popular database management systems in the it industry?
what is the command line end user interface - mysql? : Sql dba
Is sql a oracle?
What is the use of non clustered index?
