how to find nth highest salary
- 103 Answers
- 163929 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / aravinda
try with this query you will get desired position salary.
Select Salary From Employees a Where 1=(
Select Count(Distinct Salary) From Employees b
Where a.Salary <= b.Salary );
just replace where clause number for desired position. ,2,3,4
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain transaction server distributed transaction?
How can you ensure that the database and sql server based application perform well?
What are a scheduled jobs or what is a scheduled tasks?
Explain what is use of dbcc commands?
What are the advantages of passing name-value pairs as parameters?
What samples and sample databases are provided by microsoft?
How to encrypt Strored Procedure in SQL SERVER?
What are examples of triggers?
Is sql server free?
What is temporal data type?
Does sql server use java?
What is exporting utility?
Can you import Microsoft Excel data to SSRS?
What is ms sql server service broker?
What is sql server agent and what are the two modes of authentication in sql server?
