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

Does sql between include endpoints?

992

explain primary keys and auto increment fields in mysql : sql dba

966

What is clustered and nonclustered index in sql?

935

What is t sql used for?

1010

What is compilation error in pl sql?

970

What is the command used to fetch first 5 characters of the string?

1386

What types of commands can be executed in sql*plus?

1101

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1338

What is aggregate function in sql?

1028

Does inner join return duplicate rows?

968

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1051

Is ms sql traffic encrypted?

915

What are all the different types of indexes?

1145

What is pl sql block structure?

1031

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

992