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

Why we use sql profiler?

913

What is %s in sql?

972

How can you get sql*loader to commit only at the end of the load file? : aql loader

965

What is set serveroutput on in pl sql?

1196

What are the triggers associated with image items?

998

What is using in sql?

1016

what are date and time functions in mysql? : Sql dba

925

What does over partition by mean in sql?

920

Can we rollback after truncate?

980

What are the types of functions in sql?

966

what is sql in mysql? : Sql dba

1121

What is rtm in testing?

1038

What is the advantage of index in sql?

915

what are local and global variables and their differences? : Sql dba

1009

What are the different sql languages?

985