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

can sql servers linked to other servers like oracle? : Sql dba

1010

What is dbo in sql?

973

What are analytical functions in sql?

1033

Is ms sql is free?

1025

What is output spooling in sql*plus?

1039

What is sql catalog?

1026

Can there be 2 primary keys in a table?

997

Why is sharding used?

1003

How do you update a sql procedure?

1032

Can triggers stop a dml statement from executing on a table?

1102

What is bitemporal narrowing?

1311

Explain the insert into statements in sql?

1010

What is a primary key called that is made up of more than one field?

1352

what is the difference between join and union? : Sql dba

1117

What is sql resultset?

991