how to find nth highest salary
Answer Posted / kavitha. r
select top 1 salary from employee where salary in (select
top n salary from employee order by salary desc) order by
salary desc
| Is This Answer Correct ? | 12 Yes | 40 No |
Post New Answer View All Answers
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
Can binary strings be converted into numeric or float data types?
What is the maximum size of column in sql server?
What do we have to check in database testing?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What are views in ms sql server?
How dts is used to extract, transform and consolidate data?
Explain subquery and state its properties?
What is cte (common table expression)?
What is SQL Azure Federations?
Explain what is “asynchronous” communication in sql server service broker?
What is a collation in ms sql server?
How do I manually uninstall an instance of sql server 2016?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
What is the difference between system objects and user objects?