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
- 10534 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
Why use “pivot” in sql server?
How can sql injection be stopped? : sql server security
What is raid? : SQL Server Architecture
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
How to modify the underlying query of an existing view?
What is the benefit of normalization?
Explain try...catch with sql server?
What is report server project?
Can select statements be used on views in ms sql server?
What are constraints?
How to create view in stored procedure sql server?
What is primary key and example?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is scd (slowly changing dimension)? : sql server analysis services, ssas
How do I view a stored procedure in sql server query?
