select max(sal) from emp where sal=(select max(sal) from emp where sal&l

can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com

Question Posted / pravin

Answer Posted / pravin

select max(sal) from emp
where sal=(select max(sal)
from emp
where sal<(select max(sal)
from emp))

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the purpose of indexes?

983

How data can be copied from one table to another table?

954

Give me a SQL Query to find out the second largest company?

1169

What is difference between clustered and non clustered index?

990

Differentiate between ms sql server reporting services vs crystal reports?

913

What are the basic features of a trigger in ms sql server?

1202

whats new about truncate in sql server 2008?

2508

What are the joins in sql server? : sql server database administration

1016

What is a Join and explain its types?

1106

How will you make an attribute not process? : sql server analysis services, ssas

1095

How do use Having,Group by,Group function in SQL?

1749

What does dml stand for?

952

How can you fetch alternate records from a table?

964

What are system databases into sql server (2005/2008) : sql server database administration

1019

what's the information that can be stored inside a bit column? : Sql server database administration

1038