how to find nth highest salary
Answer Posted / saurabh
select max(salary) from Employee where salary not in (
select top 5 Salary from ( select distinct Salary from
Employee order by Salary desc))
Is This Answer Correct ? | 0 Yes | 11 No |
Post New Answer View All Answers
What is sql or structured query language?
Explain about remote stored procedure?
What is inline table-value user-defined function?
How global temporary tables are represented and its scope?
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?
Explain the disadvantages of cursors?
Other than truncate statement, which other command can by-pass the trigger on the tables?
How we create SQL Server 2005 Reporting Services ? Give me Sample
Can you force a query to use a specific index?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What is the use of keyword with encryption. Create a store procedure with encryption?
Do you know what guidelines should be followed to help minimize deadlocks?
What is a filestream?
How do I find the query plan in sql server?
How to find the version of sql server? : sql server database administration