select * from (select row_number() over (order by salary asc) as "

find out the third highest salary?

Question Posted / siddharth mitra

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

Answer Posted / siddharth mitra

select *
from (select row_number() over (order by salary asc) as
"ROW_NUM" from emp)
where ROW_NUM = 3;

This only works with oracle 8i and 9i,i.e., row_number is an
analytic function.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which is better Oracle or MS SQL? Why?

5038

What is a partition in oracle?

1207

Why does oracle 9i treat an empty string as null?

1130

What are the limitations oracle database 10g xe?

1097

How do we get field details of a table?

1030

Is insert autocommit in oracle?

1134

How to write an inner join with the where clause in oracle?

1091

What is a parameter file in oracle?

1191

Can you assign multiple query result rows to a variable?

1039

What is where clause in oracle?

1077

What is the difference between a primary key & a unique key?

1141

How to create id with auto_increment on oracle?

1043

How to build data dictionary view an new database?

1052

How to connect to oracle using service name instead of sid?

1072

How to invoke the data pump export utility?

1255