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
- 22931 Views
- I also Faced
- E-Mail Answers
Answer Posted / b.v.rajaram
delete top (select count(*)-(select count(distinct empname )
from Employee) from Employee)from Employee
where a in (select distinct a from Employee)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
How do I find query history in sql server?
List the ways in which dynamic sql can be executed?
Why we use the openxml clause?
How can you append an identity column to a temporary table?
Can sql servers link to other servers like oracle?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
How to convert character strings into numeric values?
Explain “row_number()” in sql server with an example?
What is the difference between upgrade and migration in sql server?
How can we solve concurrency problems?
What are the different subsets of sql?
When should you use an instead of trigger?
Can you index views?
Disadvantages of the indexes?
