select * from (select sal, rownum r from Employee order by sal desc) wher

find out the third highest salary?

Question Posted / chandiran

92 Answers
150723 Views
CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
E-Mail Answers

Answer Posted / chandiran

select * from (select sal, rownum r from Employee
order by sal desc)
where r=3

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to calculate date and time differences in oracle?

1039

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1947

How do we get field details of a table?

978

How is it different from a normal table?

1030

How to select an oracle system id (sid)?

1064

Is truncate autocommit in oracle?

1082

How to select some rows from a table in oracle?

1076

How to export data with a field delimiter?

1037

Why is oracle database so popular?

993

How to assign data of the deleted row to variables?

1073

What is Reduced List of Values?

2160

What is a snapshot in oracle database?

1025

Oracle

2375

What are the built-in functions used for sending Parameters to forms ?

3384

Give the different types of rollback segments.

1030