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

What is sql query optimization?

548

Is id a reserved word in sql?

667

What is use of package in pl sql?

534

Is it important to partition hard disk?

536

Can we create clustered index without primary key?

525

what are the join types in tsql? : Transact sql

577

Does sql profiler affect performance?

561

What is trigger types in sql?

537

what is commit? : Sql dba

619

Why procedure is used in sql?

536

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

559

What is loop in pl sql?

576

what is an extent ? : Sql dba

584

Which sql most popular?

565

Can we create view in stored procedure?

526