Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in same table
- 13 Answers
- 24940 Views
- TCS, I also Faced
- E-Mail Answers
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 are hotfixes and patches?
What is delimiter in pl sql?
What is the difference between drop and truncate commands?
What is a join query?
what are different types of collation sensitivity? : Sql dba
What is cte sql?
How can the performance of a trigger be improved?
What are the methods of filing?
What is character functions?
Is pl sql a scripting language?
Can we edit a view in sql?
Which nosql database is best?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What do you mean by table in sql?
How many triggers can be applied to a table?
