select emp_id,sal from ( select emp_id,sal from emp where sal

find out the second highest salary?

Question Posted / akash

Answer Posted / akash

select emp_id,sal from ( select emp_id,sal from emp where
sal < ( select max(sal) from emp) order by sal desc ) where
rownum < 2;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to commit the current transaction in oracle?

1047

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2210

What are the advantages of oracle 12c?

1120

How to define an explicit cursor in oracle?

989

What is the minimum client footprint required to connect c# to an oracle database?

1019

What happens if recursive calls get out of control?

1000

How to import one table back from a dump file?

972

what is the dual table in oracle?

934

What exactly do quotation marks around the table name do?

918

What is ceil and floor in oracle?

1011

What are the ways tablespaces can be managed and how do they differ?

2274

How to set a transaction to be read only in oracle?

1033

How to add a new column to an existing table in oracle?

1071

How to use subqueries in the from clause in oracle?

1045

List out the difference between commit, rollback, and savepoint?

987