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 the maximum number of rows in sql table?

1075

When is the update_statistics command used?

1182

What is the primary use of normalization?

1053

What is embedded sql with example?

1096

difference between anonymous blocks and sub-programs.

1188

how can we know the count/number of elements of an array? : Sql dba

1107

How to get help at the sql prompt?

1163

how can we destroy the session, how can we unset the variable of a session? : Sql dba

1048

How do I make my sql query run faster?

1016

What is posting?

1083

What is pl sql collection?

1017

How to install oracle sql developer?

1095

What are the different type of joins in sql?

997

What is a mutating table and a constraining table?

1178

Differentiate between syntax and runtime errors.

1238