DELETE FROM EMP E1 WHERE ROWID <(SELECT MAX(ROWID) FROM EMP E2 WHERE E1

write a query to delete similar records in same table

Question Posted / raj

Answer Posted / raj

DELETE FROM EMP E1
WHERE ROWID <(SELECT MAX(ROWID) FROM EMP E2 WHERE E1.ENO =
E2.ENO)

Is This Answer Correct ?

25 Yes

3 No

Please Help Members By Posting Answers For Below Questions

what are aggregate and scalar functions? : Sql dba

544

what is data integrity? : Sql dba

591

How do I create a sql script?

529

what is 'mysqlimport'? : Sql dba

568

what is auto increment? : Sql dba

563

What happens when a trigger is associated to a view?

494

What is sequence in sql?

499

What is sqlcontext?

546

What is record in pl sql?

587

How to check if a column is nullable before setting to nullable?

576

What are the different types of constraints?

556

explain mysql aggregate functions. : Sql dba

541

what is denormalization. : Sql dba

538

Why we use sql profiler?

554

How many primary keys can a table have?

526