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
What is t-sql? : Transact sql
What are all different types of collation sensitivity?
How can you load multi line records? : aql loader
what is online transaction processing (oltp)? : Sql dba
What is a dynamic query?
what is subquery? : Sql dba
What is compute?
how to create a new view in mysql? : Sql dba
What are the three forms of normalization?
what are null values? : Sql dba
What is union and union all keyword in sql and what are their differences?
How do I pipe the output of one isql to another?
what is the difference between a web-garden and a web-farm? : Sql dba
What is update query?
How do I turn a list into a table?