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
- 10067 Views
- I also Faced
- E-Mail Answers
Answer Posted / dinesh gupta
Kumar your query do not solve the purpose accurately.
It should be as
Delete from employee where empid
not in (Select min(empid) from employee group by empname
having count(empname)>=1)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the basic functions for master, msdb, model, tempdb and resource databases?
What is the command dbcc checkdb used for?
What is indexed view?
What is the log shipping?
Can a unique index be created on a column, which contains null?
What is the stuff and how does it differ from the replace function?
What is a database in ms sql server?
What is use of dbcc commands?
Why do we use stored procedures in sql server?
How exceptions can be handled in sql server programming?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What is the difference between Triggers and Stored Procedure?
Explain what is raid and what are different types of raid levels?
What is tablesample?
