how to find nth highest salary
Answer Posted / kavitha.r
Sorry. This one is correct
select top 1 salary from employee where salary in (select
distinct
top n salary from employee order by salary desc) order by
salary asc
| Is This Answer Correct ? | 44 Yes | 18 No |
Post New Answer View All Answers
What is coalesce and check constraint in sql server?
How do I trace a query in sql server?
What information is maintained within the msdb database?
What is the exact numeric data type in sql?
When you should use a low fill factor?
Explain system functions or built-in functions? What are different types of system functions?
What is ms sql server triggers?
Do I need a report server to run reports in my application?
How can we get count of the number of records in a table?
How do you Implement SSIS Packages in your Project?
Explain encryption of entire databases without the need for application changes in sql server 2008?
How to download microsoft sql server 2005 express edition?
How to delete a login name in ms sql server?
What is transaction server explicit transaction?
What is a select query statement in ms sql server?