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
- 10330 Views
- I also Faced
- E-Mail Answers
Answer Posted / kumar
Table structure :-
empid empname
1 bala
2 bala
3 bala
4 bala
5 arun
6 arun
7 arun
8 ram
9 ram
Delete from employee where empid
not in (Select min(empid) from employee group by emp
having count(empid)>1)
By
Kumar
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the limitations/drawbacks or ssrs 2008 r2?
How do I start sql server agent automatically?
Describe how to use the linked server?
What are the differences between user defined functions and stored procedures?
What is user-defined function?
What is server-level principal?
What is a view and what are its advantages?
Tell me when is the update_statistics command used?
Why we use trigger in sql server with example?
Explain foreign key in sql server?
Is it important for a database administrator to understand the operating system and file access?
What are transactions in sql?
What is the process of normalization?
What is database isolation in sql server? : sql server database administration
What are differences in between sql server 2012 and sql server 2016?
