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
- 20173 Views
- I also Faced
- E-Mail Answers
Answer Posted / v.krishnakumar
using the keyword distinct we can avoid the duplicate value
in our table,(ex) SELECT DISTINCT empname FROM Employee
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Is candidate a key?
What are the main differences between #temp tables and @table variables and which one is preferred?
Can you create a logon trigger in sql server 2005 express edition?
How to skip remaining statements in a loop block using continue statements?
Explain an incremental backup?
What is a schema in ms sql server 2005?
What is your recommendation for a query running very slow? : sql server database administration
Define a cross join?
Tell me about normalization in DBMS.
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
Does union all remove duplicates?
What is indexing in sql server with example?
What is database white box testing?
What is primary key index?
If no size is defined while creating the database, what size will the database have?
