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

When we should use @@error?

937

What is an etl file?

921

How do you troubleshoot errors in a SQL Server Agent Job?

1025

State a few properties of relational databases?

1092

What is normalization? Explain different forms of normalization?

1099

What is nested transaction?

1065

What options are available to audit login activity? : sql server security

1116

How to recreate an existing index in ms sql server?

1013

What is resource db in sql server?

980

What is tempdb database? : SQL Server Architecture

1146

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2734

What is a database in ms sql server?

1016

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1026

What are the differences between decimal and float in ms sql server?

1170

How to name query output columns in ms sql server?

933