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

how to find the second highest salary from emp table?

Question Posted / anantkreshna v

Answer Posted / anantkreshna v

select max(sal) from emp_table where sal < (select max(sal)
from emp_table);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is pl sql different from sql?

1001

How many sql core licenses do I need?

949

What are different sql data types?

1051

Which is better join or inner query?

1052

Is ms sql traffic encrypted?

929

Enlist the advantages of sql.

1001

What is sql scripting?

1124

What is scalar function in sql?

1044

How to execute a stored procedure?

1095

When sql appeared?

1103

How can get second highest salary in sql?

990

What is sap sql anywhere?

1084

What are types of indexes in sql?

1084

How do I run a program in pl sql?

1007

how to include numeric values in sql statements? : Sql dba

1103