Select sal from emp where sal < (select max(sal)from emp) and rownum &l

how to find the second highest salary from emp table?

Question Posted / jigar r gor

Answer Posted / jigar r gor

Select sal from emp where sal < (select max(sal)from emp)
and rownum < 2 order by sal desc

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a join query?

908

What is the usage of the distinct keyword?

1169

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

927

What is the difference between in and between in sql?

996

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

903

What is dcl in sql?

907

Who is the owner of mysql database?

1002

What is sql query optimization?

1023

Which is faster union or join?

903

what is a materialized view? : Sql dba

999

What is the difference between python and sql?

940

what is blob? : Sql dba

1056

Is natural join and inner join same?

854

Can procedure in package be overloaded?

1030

Why do you partition data?

967