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

find out the third highest salary?

Question Posted / siddharth mitra

92 Answers
147716 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

Is there any function in oracle similar like group_concat of mysql?

989

Explain an index segment?

1043

What is a initialization parameter file in oracle?

989

What is memory advisor in Oracle?

1027

What happens if variable names collide with table/column names?

1105

What are the execution control statements in oracle?

1028

How to resolve name conflicts between variables and columns?

982

What is meant by joins?

1015

What is concurrency in oracle?

949

Does oracle partitioning improve performance?

947

How to commit the current transaction in oracle?

1047

What is a server parameter file in oracle?

1004

How to call a stored function in oracle?

953

How to get last row id?

941

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2398