Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 22306 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
Are connections to sql server encrypted?
What is acid mean in sql server?
What is table valued function and scalar valued functions?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
How do I start sql server 2016?
How to insert new line characters into strings?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is use of except clause? How it differs from not in clause?
What is the syntax for encrypting a column in SQL Server?
What are SSL and TSL protocols?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
Do you know what is lock escalation?
What is sql sandbox in sql server?
What is a derived table?
Explain tablesample?
