Interested to Buy Any Domain ? << Click Here >> for more details...
in tabase table having a column in it empname field is
there which having 5 duplicate values is there i want
deleted all the duplicates i want showing only one name
only.
- 7 Answers
- 10258 Views
- I also Faced
- E-Mail Answers
Answer Posted / karna
delete from emp where empid not in(select max(empid) from
emp group by empname having count(*)>=1)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the new data types are introduced in sql 2000?
Which database stores information about replication?
How can you start sql server in different modes?
What are the advantages of the mirroring?
How do I start sql server?
What is the syntax for encrypting a column in SQL Server?
Tell me when is the update_statistics command used?
Explain what is the use of custom fields in report?
What is the difference between a clustered index and a non-clustered index?
How do I start sql server agent automatically?
Delete duplicate rows without using rowid.
Is null in sql server?
Explain few examples of RDBMS?
What is explicit mode in sql server?
What is amo? : sql server analysis services, ssas
