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
- 20109 Views
- I also Faced
- E-Mail Answers
Answer Posted / navneet sharma
select distinct * from tablename
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of the master database?
Why SQL Agent is used?
What are filegroups in sql server?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What stored by the model? : sql server database administration
How do you rebuild an identity column?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What are the disadvantages of indexes?
If we delete pack Spec what will be the status of pack Body ?
Do you know what is blocking?
What is cube dimension? : sql server analysis services, ssas
Difference between drill down and drill through report.
What is awe?
Explain transaction server explicit transaction?
What is a full text index?
