select max(sal) from emp_det where sal not in ( select max(sal) from emp

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

Question Posted / swapnl

Answer Posted / swapnl

select max(sal) from emp_det where sal not in (
select max(sal) from emp_det);

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to insert new line characters into strings?

1034

How to configure and test odbc dsn settings?

1227

define and explain the differences between clustered and non-clustered indexes.

1254

What are the advantages of partitioning?

1180

What are the rules to use the rowguidcol property to define a globally unique identifier column?

1078

What are the mathematical functions supported by sql server 2005?

1128

What the class forname () does?

1142

Where cross join is used?

1033

Can sql servers linked to other servers like oracle?

1011

What is ssrs?

135

What do you understand by coalesce in sql server?

1129

How many instances per computer are there in sql server 2000?

1122

How to see the event list of an existing trigger using sys.trigger_events?

1137

How to disable a login name in ms sql server?

1176

Write a program to fetch first 10 records from a file?

1065