Interested to Buy Any Domain ? << Click Here >> for more details...
how to find nth highest salary
- 103 Answers
- 178800 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / parmesh m
select top 1 salary from Employee where salary in (
select top n salary from Employee
group by salary
having count(salary )< n+1
order by salary desc )
order by salary
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I port a number to sql server?
What is an execution plan? How would you view the execution plan?
How do I run sql server 2014?
Explain the benefits of user-defined functions?
What is BCNF? How is it better than 2NF & 3NF?
How to create a simple stored procedure in ms sql server?
Explain about service Broker functions?
What is user defined stored procedures?
Determine when an index is appropriate?
What is data compression? : sql server database administration
How much is a sql server license?
What is table value parameters (tvp)?
How to update values in a table with update statements in ms sql server?
How important do you consider cursors or while loops for a transactional database?
What is 'Join' and explain its various types.
