DELETE emp WHERE ROWID NOT IN(SELECT MIN(eid)FROM emp GROUP BY eid);

write a query to delete similar records in particular
fields(columns) in different tables

Question Posted / rajesh

Answer Posted / rajesh

DELETE emp WHERE ROWID NOT IN(SELECT MIN(eid)FROM emp GROUP
BY eid);

Is This Answer Correct ?

1 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Explian rowid, rownum?

560

what is recursive stored procedure? : Sql dba

526

What is dcl in sql?

526

Is there any restriction on the use of union in embedded sql?

669

What is sql catalog?

560

what is 'mysqlimport'? : Sql dba

570

Is not equal in sql?

564

what is not null constraint? : Sql dba

546

What is the use of partition by in sql?

514

What is the least restrictive isolation level? : Transact sql

565

What does (*) mean in sql?

527

what is 'mysqld'? : Sql dba

540

What is the difference between nvl function, ifnull function, and isnull function?

587

Does truncate table reset auto increment?

528

Mention what plvcmt and plvrb does in pl/sql?

636