select max(sal) from emp where sal < (select max(sal) from emp)

how to find the second highest salary from emp table?

Question Posted / muhammed zaheer

Answer Posted / muhammed zaheer

select max(sal) from emp where sal < (select max(sal) from
emp)

Is This Answer Correct ?

86 Yes

16 No

Please Help Members By Posting Answers For Below Questions

How to get help at the sql prompt?

1052

What is clustered index in sql?

997

what is not null constraint? : Sql dba

963

what is a unique key ? : Sql dba

1024

Can a key be both primary and foreign?

943

What is the use of function in sql?

1026

Explain the difference between drop and truncate commands in sql?

957

Explain alias in sql?

991

Which version of sql do I have?

994

What is a string data type in sql?

956

what are the authentication modes in sql server? How can it be changed? : Sql dba

1314

What is the difference between rename and alias?

1266

Explain the difference between rename and alias?

963

Explain normalization and what are the advantages of it?

890

Does sap use sql?

927