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 we call a function containing dml statements in a select query?

958

Can we join same table in sql?

993

What will you get by the cursor attribute sql%rowcount?

1017

Can we call procedure in select statement?

1034

what is a record in a database ? : Sql dba

1042

Why do we create stored procedures & functions in pl/sql and how are they different?

923

write an sql query to find names of employee start with 'a'? : Sql dba

1010

What is snowflake sql?

1048

What is the usage of sql functions?

1128

What does <> sql mean?

1056

What is over () in sql?

927

What are the main features of cursor?

1065

Are dml statements autocommit?

1023

What is trigger in flip flop?

997

how can you see all indexes defined for a table? : Sql dba

975