write a query to delete similar records in same table
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 |
Post New Answer View All Answers
Does sql between include endpoints?
explain primary keys and auto increment fields in mysql : sql dba
What is clustered and nonclustered index in sql?
What is t sql used for?
What is compilation error in pl sql?
What is the command used to fetch first 5 characters of the string?
What types of commands can be executed in sql*plus?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What is aggregate function in sql?
Does inner join return duplicate rows?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
Is ms sql traffic encrypted?
What are all the different types of indexes?
What is pl sql block structure?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba