SELECT * FROM Emp e1 WHERE 2 = (SELECT COUNT(*) FROM Emp e2 WHERE e1.Salar

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

Question Posted / krishna mohan thamisetty

Answer Posted / krishna mohan thamisetty

SELECT * FROM Emp e1
WHERE 2 = (SELECT COUNT(*) FROM Emp e2 WHERE e1.Salary <=
e2.Salary)

Is This Answer Correct ?

6 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is raid? : SQL Server Architecture

1181

What are extended events in sql server?

955

how will add additional conditions in sql?

1108

What are database states in ms sql server?

1181

What is dbcc updateusage?

1205

How to rename an existing column with sql server management studio?

999

What are the types of sql server?

1054

Tell me what is difference between view and materialized view?

938

Tell me the phases a transaction has to undergo?

963

What is a data source or ds? : sql server analysis services, ssas

1007

What are the recovery models for a database?

1107

How many replicas are maintained for each SQL Azure database?

142

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1115

When would you prefer to have a minimum number of indexes?

911

How do you start single user mode in clustered installations?

942