how to find nth highest salary
Answer Posted / suhail qaiser
SELECT TOP Nth salary
FROM (
SELECT TOP N salary
FROM emp
ORDER BY salary DESC
) TmpTable
ORDER BY salary ASC
| Is This Answer Correct ? | 38 Yes | 56 No |
Post New Answer View All Answers
What is mean by dml?
what stored procedure can you use to display the current processes? : Sql server administration
ow to bring suspect mode datbase online from scratch
What do you know about system database? : SQL Server Architecture
How do I view a trc file?
What is sql server profiler?
What is user-defined multi-statement table-valued function?
can you instantiate a com object by using t-sql? : Sql server database administration
How to convert numeric expression data types using the cast() function?
What is difference between count (*) and count 1?
How to add a new dsn with the odbc driver for sql server?
What is @@rowcount in sql?
What is default constraint in ms sql server?
Describe triggers features and limitations?
How many databases Microsoft SQL server provides?