select top 2(salary) from emp_sal where salary in (select sal from emp

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

Question Posted / ravikiran

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is the Difference Between Primary and Foreign Key?

960

Explain insert into select statement?

902

Define outer join in sql server joins?

892

What is truncate table?

892

What is conditional split?

997

what are constraints? : Sql server database administration

984

What is the maximum size of column in sql server?

850

What is catalog views?

1026

How do you delete duplicate rows in sql server?

901

What are cascading parameters in ssrs reports?

212

Explain different types of lock modes in sql server 2000?

885

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

895

What is perspective, have you ever created perspective? : sql server analysis services, ssas

861

What is the recursive stored procedure in sql server?

968

What is a self join in sql server?

1057