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
- 10313 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 is inner join in sql server joins?
What is a periodical index?
Why I have to use stored procedures?
What is SQL Azure Federations?
How to turn off warning messages during php execution?
Explain use of expression builder.
What is sql server used for?
What is Federation and Federation Member?
How to return the date part only from a sql server datetime datatype?
How can you know if the row fetched from cursor is still valid in underlying table?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
How to count rows with the count(*) function in ms sql server?
What are information schema views?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
Which tools are available to manage SQL Azure databases and servers?
