Interested to Buy Any Domain ? << Click Here >> for more details...
Delete duplicate rows from a table without primary key by
using a single query
Table Employee
empname salary
A 200
B 300
A 200
C 400
D 500
D 500
Output should be
A 200
B 300
C 400
D 500
- 14 Answers
- 22666 Views
- I also Faced
- E-Mail Answers
Answer Posted / sumathy
Execute the following query for each duplicate value.
1.Delete duplicate of empname='A'
delete top(select count(*)-1 from employee where
empname='A') from employee where empname='A'
2.Delete duplicate of empname='D'
delete top(select count(*)-1 from employee where
empname='D') from employee where empname='D'
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What happens when converting big values to numeric data types?
Can you please explain the difference between function and stored procedure?
How to retrieve error messages using odbc_errormsg()?
Explain ms sql server reporting services vs crystal reports?
what stored procedure would you use to view lock information? : Sql server administration
What is the use of builtinadministrators group in sql server? : sql server security
What is RMS migrations?
What is a ddl statement?
How do I find the sql server version?
Name few of the dcl commands in sql?
What is the server name in sql server?
What is the maximum size per database for sql server express?
how can you attach more than 20 ldf files in sql server
How to find the version of sql server? : sql server database administration
What is merge?
