how to find nth highest salary
- 103 Answers
- 163907 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / lakshmi reddy
To get nth highest salary from Employee table:
select * from Employee e where n=(select COUNT(distinct sal)
from Employee e2 where e2.Sal>e.Sal)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are drillthrough reports?
What is optimistic concurrency?
What is difference between inner join and full join?
What is statement level trigger?
What do you mean by the term 'normalization'?
Explain about sql server login?
difference between Clustered index and non clustered index ?
Explain system functions or built-in functions? What are different types of system functions?
What are the general features of sql server management studio? : sql server management studio
What to perform pattern match with the like operator?
What does it mean to normalize data?
what are acid properties? : Sql server database administration
Why use “in” clause in sql server?
Can you pass expressions to function parameters?
Do you know what guidelines should be followed to help minimize deadlocks?
