select *from(select ename,sal,row_number()over(order by sal desc) rk from e

Select the Nth lowest value from a table?

Question Posted / mahesh

4 Answers
5302 Views
I also Faced
E-Mail Answers

Answer Posted / mahesh

select *from(select ename,sal,row_number()over(order by sal desc) rk from emp) where rk=2;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you bind variables in oracle?

928

What is difference between truncate and delete?

973

How to use in conditions in oracle?

994

Which is better Oracle or MS SQL? Why?

4823

Is oracle an operator?

882

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2197

Explain do view contain data?

940

How to pass a cursor variable to a procedure?

1039

Explain the use of indexes option in exp command.

1063

What is materialized view in Oracle?

1042

State and explain the different types of data models?

893

What is merge in oracle?

994

How to write a query with an inner join in oracle?

972

Point out the difference between user tables and data dictionary?

930

What is an oracle user role?

937