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
- 18581 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 row_number function?
Tell me what is the stuff and how does it differ from the replace function?
How to drop an existing user defined function in ms sql server?
what are the core components of SSRS?
Is sql server difficult to learn?
What is report server project?
What is difference between after and before?
How to get the number of affected rows?
Can a database be shrunk to 0 bytes, if not, why?
Explain activity monitors
How can you insert null values in a column while inserting the data?
Is mysql the same as sql server?
How to list all tables in the database using odbc_tables()?
Can two tables share the same primary key?
how to do partition in sqlserver
