how to find nth highest salary
Answer Posted / venuprasadh
SELECT MIN(SALARY) AS Salary FROM user WHERE SALARY IN
(SELECT DISTINCT TOP 3 SALARY FROM user ORDER BY SALARY DESC);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to enter binary string literals in ms sql server?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
How can I add Reporting Services reports to my application?
What is the beast way to write CTE in SQL Server ?
Why I am getting this error when dropping a database in ms sql server?
What are the default system databases in sql server 2000?
Which joins are sql server default?
What is candidate key with example?
Does hive support indexing?
How can we remove orphan records from a table?
Explain isolation levels that sql server supports?
List out what other servers you can use with ssrs?
How do I start sql server 2016?
what is the difference between a primary key and a unique key? : Sql server database administration
What is partitioned view?