how to find nth highest salary
Answer Posted / arun
SELECT MAX(salary)FROM employee WHERE salary NOT IN
(SELECT TOP 1 salary FROM employee ORDER BY salary DESC)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the importance of concurrency control?
What are the different ways you can create databases in sql server?
what is package and it uses and how can u call a package
Where cross join is used?
What is updatable resultset?
What is the purpose of linked server configuration in sql server?
How to enable/disable indexes?
Where the sql logs gets stored?
What is multi-statement table-value user-defined function?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
Explain what is use of dbcc commands?
What are binary string data types in ms sql server?
What is exporting and importing utility?
Does any body please help me what question's have asked for SSRS in the interview?
What are “lost updates”?