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
- 22278 Views
- I also Faced
- E-Mail Answers
Answer Posted / jansi rani
SELECT EMPNAME,SAL FROM EMP GROUP BY EMPNAME,SAL
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is a select query statement in ms sql server?
How to deploy the Report?
Is natural join and equi join same?
What is difference between count (*) and count column?
Explain security with sql azure?
What is a trigger what are the advantages of trigger?
What is the difference between dbcc indexdefrag and dbcc reindex?
What are the properties and different types of sub-queries?
How to resolve the orphan use problem? : sql server security
What is the Disadvantage of indexed sequential file.
what authentication modes does sql server support? : Sql server database administration
tell me the disaster recovery plan
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What are the purposes of floor and sign functions?
What are the restrictions that views have to follow?
