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 clr ddl trigger?

914

How to verify a user name with sqlcmd tool?

1023

How can you append an identity column to a temporary table?

877

What is temporal table?

827

Explain primary key in sql server?

974

What is the purpose of sql profiler in sql server? : sql server database administration

1044

Explain the ways to controlling cursor behavior?

876

How is SQL Azure different than SQL server?

223

What functions can a view be used to performed?

1001

Define right outer join in sql server joins?

983

Explain the difference between HTTP and HTTPS in database?

976

What is the bookmark lookup and rid lookup?

944

Explain go command in sql server?

970

What are the kinds of subquery?

952

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1016