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
Answer Posted / navneet sharma
select distinct * from tablename
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Do you know what is similarity and difference between truncate and delete in sql?
Explain the difference between HTTP and HTTPS in database?
What happens if null values are involved in arithmetic operations?
query processing
How can you append an identity column to a temporary table?
What is nonclustered index on computed columns?
How does the report manager work in SSRS?
Tell me what is de-normalization and what are some of the examples of it?
Explain about service Broker functions?
How does clustered and non clustered index work?
How do I find information about the install locations for the various instances running on a computer?
How to rebuild indexes with alter index ... Rebuild?
What are the export options of ssrs?
Do you know the cursor types?
What happens if null values are involved in bitwise operations?