how to find nth highest salary
Answer Posted / ankur bakliwal
I think this should work -
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 ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is command parameter in ssrs?
What is fill factor and pad index?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
State the difference between local and global temporary tables?
Name three of the features managed by the surface area configuration tool? : sql server security
what stored procedure can you use to display the current processes? : Sql server administration
How to perform key word search in tables?
What is a partition key?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
Explain what is scheduled job and how to create it?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What are orphan records?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What is the need for indexing?
What do you understand by integration services in sql server?