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

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

Please Help Members By Posting Answers For Below Questions

How many types of tables are there in oracle?

1112

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1089

What do you mean by group by clause?

1094

Explain enable novalidate constraint.

1132

What is oracle analytical function?

1234

Define oracle database

1099

Explain oracle instance.

1234

How to define a sub function?

1203

What are the attributes that are found in a cursor?

1122

How to start instance with a minimal initialization parameter file?

1085

How to insert a new row into a table in oracle?

1218

what is difference between sql plus and sql*plus? (not sql and sql plus).

3943

Explain the truncate in oracle?

1014

What privilege is needed for a user to create indexes in oracle?

1085

Give the advantages and disadvantages of clusters.

1097