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

Differentiate between function and procedure in oracle.

1050

Explain oracle left join with an example?

986

What is a proxy class?

1018

What are the database administrators utilities available?

1009

What is the exact use of Collections?

2130

How does Oracle guarantee data integrity of data changes?

2370

what are archived logs?

2182

What is the difference between "as" and "is" in an oracle stored procedure?

977

What is a trigger and what are its types in oracle?

1054

What is analyze command used for?

1044

What is memory advisor in Oracle?

1059

What is an external table?

999

Can we protect our pl/sql source code?

1028

How to convert a string to a date in oracle database?

1031

What is the max number of columns in an oracle table?

976