To find the 2nd highest salary from emp table: select max(sal) from emp

how to find the second highest salary in a given table????

Question Posted / shahnaz

Answer Posted / shahnaz

To find the 2nd highest salary from emp table:

select max(sal) from emp where sal not in (select max(sal)
from emp )

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to check database size in Oracle?

1194

Explain do view contain data?

1016

How will you identify oracle database software release?

1013

What are the limitations oracle database 10g xe?

1046

What is the simplest tool to run commands on oracle servers?

1012

Which are the five query types available in oracle?

951

What do you mean by merge in oracle and how can you merge two tables?

949

What is the difference between 10g OEM and 11g OEM?

966

How do I escape a reserved word in oracle?

1201

How to connect to the server with user account: sys?

1024

How to synchronize 2 schema's objects?

2183

Explain how are indexes update?

1068

How to rename an index?

1074

What is null value in oracle?

1098

How to do a full database export?

1115