how to find nth highest salary
Answer Posted / sharmila shree
SELECT TOP 1 salary FROM
( SELECT DISTINCT TOP 1 salary FROM table_name
ORDER BY salary DESC )
a ORDER BY salary
here 'a' is sub query of salary
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is clustered primary key?
What is difference between foreign key and unique key?
How to remove duplicate rows from table?
What is data source view or dsv? : sql server analysis services, ssas
What is bit data type? What's the information that can be stored inside a bit column?
Where are SQL server users names and passwords are stored in sql server?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What is difference between oltp and olap?
What happens if null values are involved in bitwise operations?
What is shrink log file?
Explain the properties of a relational table?
Explain transaction server consistency?
What is self join in sql server joins?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What does the update command do?