please tell me the query to get details of the employee having the second larg

please tell me the query to get details of the employee
having the second largest salary

Question Posted / srikanth

Answers were Sorted based on User's Feedback

please tell me the query to get details of the employee having the second largest salary..

Answer / ravikiran

select top 2(salary) from emp_sal where
salary in (select sal from emp_sal order by sal desc)

Is This Answer Correct ?

2 Yes

3 No

More SQL Server Interview Questions

What does nvl stand for?

What is stored procedure in SQL..??

What is the use of toad or sqldbx.?

How will you make an attribute not process? : sql server analysis services, ssas

What is a database table?

What is an sql server agent?

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

how to find 6th highest salary

How do you delete duplicate records in sql server?

To which devices can a backup be created and where should these devices be located? : sql server management studio

Do you know clustered and non-clustered index?

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

For more SQL Server Interview Questions Click Here