how to find nth highest salary
Answer Posted / chandra sekhar
select min(salary) from emp where salary in (select top n salary from emp order by salary desc)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How do I view views in sql server?
What is default constraint?
Can we shrink data file in sql server?
What is blocking?
what are user defined datatypes and when you should go for them? : Sql server database administration
role of sql sever 2005 in database rather than any other database
How to create new table with "create table" statements?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
How do I find the sql server instance name?
Can two tables share the same primary key?
Define candidate key, alternate key, and composite key.
What is schemabinding a view?
How many types of functions are there in sql server?
What is transaction server isolation?
What command do we use to rename a db, a table and a column?