select sal from (SELECT sal, rownum row

1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.

Question Posted / neha k

Answer Posted / neha k

select sal
from (SELECT sal, rownum row_num
FROM emp
order by sal desc)
where row_num = 2;

Is This Answer Correct ?

5 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What privilege is needed for a user to create indexes in oracle?

963

Explain the use of compress option in exp command.

965

How do you find current date and time in oracle?

986

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1849

Oracle

2319

Please explain drop constraint oracle?

1027

How to insert multiple rows with one insert statement in oracle?

1020

What is the difference between pre-select and pre-query?

1123

What are transaction isolation levels supported by oracle?

994

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2077

Can we write insert statement in function in oracle?

1026

What is execute immediate in oracle?

949

How to check your oracle database 10g xe installation?

924

Explain an extent?

1048

What is the relation of a user account and a schema in oracle?

1006