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
How to know the last executed procedure?
explain mysql aggregate functions. : Sql dba
What are dml commands?
What is a natural join?
Is record in oracle pl sql?
how to drop an existing index in mysql? : Sql dba
explain the difference between myisam static and myisam dynamic. : Sql dba
What is acid property in a database?
Do prepared statements prevent sql injection?
Which table is left in left join?
What does count (*) mean?
What are all the common sql functions?
Does sql*plus also have a pl/sql engine?
How do I count duplicates in sql?
What is a common use of group by in sql?