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
Which table keeps the locking information?
How to modify the underlying query of an existing view?
Do you know the different ddl commands in sql?
What is simple indexing method?
How do I start sql server 2017?
How do I debug a stored procedure in sql server?
Define normalisation?
What are click through reports?
How to drop an existing table?
How to execute multiple stored procedures at one time in sql server?
how many no of arguments can be passed in procedures and functions
What is single-user mode?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What is the Control Flow in SSIS