write a query to delete similar records in different tables
with same structure
- 4 Answers
- 7903 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 create a new table in mysql? : Sql dba
How do I quit sql?
Mention what is the plv (pl/vision) package offers?
Why join is faster than subquery?
How do I create a sql script?
define data blocks ? : Sql dba
What are different types of queries in sql?
Is a table valued function object?
What is gpt format?
What is difference between pls_integer and integer?
what's the difference between a primary key and a unique key? : Sql dba
What are different clauses used in sql?
what is the command used to fetch first 5 characters of the string? : Sql dba
how to convert dates to character strings? : Sql dba
How to use transactions efficiently : transact sql
