select max(salary) from emp where salary<(select max(salary) from emp)

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

Question Posted / ss

Answer Posted / ss

select max(salary) from emp
where salary<(select max(salary) from emp)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the requirements on sql server network connections?

1038

What is the default server name for sql server?

1229

Can a trigger be created on a view?

992

What are the mathematical functions supported by sql server 2005?

1124

What are the lambda triggers?

956

What are triggers in ms sql server?

1224

Can two different columns be merged into single column? Show practically?

1119

What are the system database in sql server 2005?

1096

Can an automatic recovery be initiated by a user?

1066

Explain what are the restrictions while creating batches in sql server?

1112

What is view in sql?

950

Can you insert NULL in unique column?

1207

What are the difficulties faced in cube development? : sql server analysis services, ssas

1097

How do I make a resultset scrollable?

1012

Explain primary key and foreign key constraints?

1089