how to find nth highest salary
Answer Posted / parmesh m
select top 1 salary from Employee where salary in (
select top n salary from Employee
group by salary
having count(salary )< n+1
order by salary desc )
order by salary
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to write a query with an inner join in ms sql server?
What is the difference between online clustering and Offline clustering?
Explain about SQL server 2005?
Explain insert into select statement?
How to rebuild the master database?
How you can get a list of all the table constraints in a database?
What is SQL Server?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What is the difference between functions and stored procedures?
How to see existing views in ms sql server?
What is the maximum size of a row in sql server?
Explain how dts is used to extract, transform and consolidate data?
What are the advantages of paper records?
How to make a remote connection in a database?
How you provide security to cube? : sql server analysis services, ssas