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 are the two modes of authentication in sql server?

1074

Why can there be only one clustered index and not more than one?

1007

What is difference between view and materialized view?

941

Define a cross join?

1040

How to add additional conditions in SQL?

1029

What is a matrix in ssrs?

153

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1024

How column data types are determined in a view?

967

What is advantage data architect?

929

Are resultset updatable?

962

How to execute multiple stored procedures at one time in sql server?

1016

How to call a function from a stored procedure in SQL Server ?

1034

How can I change procedure name in sql server?

1055

what is a mixed extent? : Sql server administration

1110

What is difference between group by and having?

946