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 is the command used to recompile the stored procedure at run time?

1121

Define cursor locking

1061

How to join two tables in a single query in ms sql server?

1061

What is order of B+tree?

1155

What is trigger and different types of Triggers?

1201

What is updatable resultset?

1076

How to defragment indexes with alter index ... Reorganize?

1138

what are the important architecture components of SSRS?

146

How many replicas are maintained for each sql azure db?

124

What are the differences between clustered and non-clustered index?

1081

Define compound operators?

972

What samples and sample databases are provided by microsoft?

1089

What is enhanced database mirroring in sql server 2008?

1037

How global temporary tables are represented and its scope?

1017

Explain syntax for viewing, dropping and disabling triggers?

999