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 is t-sql? : Transact sql

1040

What are all different types of collation sensitivity?

1075

How can you load multi line records? : aql loader

1125

what is online transaction processing (oltp)? : Sql dba

1038

What is a dynamic query?

1073

what is subquery? : Sql dba

1187

What is compute?

1148

how to create a new view in mysql? : Sql dba

986

What are the three forms of normalization?

1092

what are null values? : Sql dba

1013

What is union and union all keyword in sql and what are their differences?

1157

How do I pipe the output of one isql to another?

1056

what is the difference between a web-garden and a web-farm? : Sql dba

1138

What is update query?

1031

How do I turn a list into a table?

1008