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 constraints and its types?

997

Differentiate between mongodb vs. Sql server?

1142

where the connection string store in the database

2122

What is a covering index?

1042

What are the security related catalog views? : sql server security

992

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

1008

What are distinctive joins find as a part of sql?

1000

How to update values in a table with update statements in ms sql server?

1061

Difference between 2NF &3NF ?

1132

what is a deadlock? : Sql server database administration

1149

What is b tree index?

966

how can u get last observation in an unknown dataset ?

2485

What number sorts of privileges are accessible in sql?

1087

Some queries related to SQL

1036

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

141