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

What is output spooling in sql*plus?

1027

What is the difference between count 1 and count (*) in a sql query?

983

What is the difference between cluster and non-cluster index?

1104

What is the usage of the distinct keyword?

1214

What is exit statement?

1009

What are the limitations of sql express?

1066

Can we call stored procedure in function?

955

explain commit and rollback in mysql : sql dba

1009

Is primary key is clustered index?

996

Explain ddl statements in pl/sql?

1007

Which is better join or inner query?

1037

What is sql injection owasp?

1056

what are the different tables present in mysql? : Sql dba

980

Why sql query is slow?

985

Is not null in sql?

988