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 are the types of variables use in pl sql?

1049

What are the parameter modes supported by pl/sql?

1117

Explain the difference between triggers and constraints?

986

Explain polymorphism in pl/sql.

1126

What are the rules to be applied to nulls whilst doing comparisons?

1331

How many postgresql users are there, worldwide?

1072

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1146

How do you pronounce sql?

1022

What is having clause in sql?

973

How to order siblings in oracle hierarchy queries?

1054

what is 'mysqldump'? : Sql dba

1115

What is sqlca in db2?

975

What are the types of join in sql?

1109

How does one load ebcdic data? : aql loader

1185

What is cost in sql execution plan?

994