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 msql? : Sql dba

943

What are some emotional triggers?

931

what is sub-query? : Transact sql

1041

What is composite primary key in sql?

941

How many disk partitions should I have?

942

What company owns postgresql?

963

What is meant by cursor in sql?

942

What is execution plan in sql?

981

Define union, minus, union all, intersect ?

950

what are the different functions in sorting an array? : Sql dba

969

What are records give examples?

954

What are the different tcl commands in sql?

1106

How do you update f as m and m as f from the below table testtable?

1792

What are instead of triggers?

997

Does user triggers have entry for trigger with compilation errors?

975