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

What are the types of processing and explain each? : sql server analysis services, ssas

1135

How will you find out if there are expensive SQL statements running or not?

1001

can an automatic recovery be initiated by a user? : Sql server administration

935

What is difference between aggregate and analytic function?

906

Explain the microsoft sql server delete command? : SQL Server Architecture

1052

How to delete an existing row with delete statements in ms sql server?

1069

What are built in functions?

981

What is the purpose of grouping data in a report?

942

How do I run a trace in sql server?

967

What is attribute relationships, why we need it? : sql server analysis services, ssas

942

What is the difference between a clustered index and a non-clustered index?

976

Which Model uses the SET concept

979

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

989

How to verify the port number of the sql server?

1124

Tell me what do you understand by a view? What does the with check option clause for a view do?

996