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

What is sql collation?

1139

How to create indexed view?

987

explain different types of backups avaialabe in sql server? : Sql server database administration

920

Explain partitioned view?

1023

How to end a stored procedure properly in ms sql server?

1019

What is bulkcopy in sql?

903

What are out-of-range errors with date and time literals?

967

List few advantages of stored procedure.

928

Mention the command used to rename the database.

948

How to disable stored procedure sql server?

1532

Detail about the hardware which is supported by SQL server?

1010

What are alternate keys?

937

How do clustered indexes store data?

1058

What are difference between Cluster index and Non-Cluster index?

1022

What is the difference between left and right outer join?

1019