delete from employee where (empid, empssn) not in ( select min

write a query to delete similar records in same table

Question Posted / bcaramu

Answer Posted / bcaramu

delete from employee
where (empid, empssn)
not in
( select min(empid), empssn
from employee group by empssn);

Is This Answer Correct ?

8 Yes

5 No

Please Help Members By Posting Answers For Below Questions

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

974

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

956

What is sqlerrd?

922

How do you modify a trigger?

876

How to convert comma separated string to array in pl/sql?

1112

What is clause in sql?

1056

What is t-sql? : Transact sql

928

How do I remove sql developer from windows 10?

1016

What is an oracle stored procedure?

990

How many triggers can be applied on a table?

882

What is query optimization in sql?

941

What is the importance of sqlcode and sqlerrm?

1280

Why stored procedure is better than query?

887

what is bcp? When does it used? : Sql dba

935

Does user triggers have entry for trigger with compilation errors?

975