how to find nth highest salary

Question Posted / mnggupta

Answers were Sorted based on User's Feedback

how to find nth highest salary..

Answer / haribabuboddapati

select max(sal)*from emp
where sal>select max(sal)*from emp

Is This Answer Correct ?

24 Yes

100 No

how to find nth highest salary..

select salary=max(salart)from from EmpMaster

Is This Answer Correct ?

17 Yes

182 No

how to find nth highest salary..

select salary=max(salart)from from EmpMaster

Is This Answer Correct ?

20 Yes

206 No

More SQL Server Interview Questions

Can we write a distributed query and get some data which is located on other server and oracle database?

Does index slows down insert statements?

Explain hostprotectionattribute in sql server 2005?

How can I get data from a database on another server?

Write the SQL query to drop, truncate and delete table.

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

What is the difference between varchar and nvarchar types?

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

What is table constraint?

What is the difference between substr and charindex in the sql server?

What is the difference between delete and truncate statements?

Explain different types of lock modes in sql server 2000?

For more SQL Server Interview Questions Click Here