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

What are the execution control statements?

1044

How to check your oracle database 10g xe installation?

967

What is an Oracle Instance?

1104

What are the various types of snapshots ?

1009

How do I limit the number of oracle database connections generated by weblogic server?

1050

Explain the use of grant option in exp command.

1034

How a database is related to tablespaces?

1015

Can we protect our pl/sql source code?

1026

how to join query for one source type is oracle another source type is sql server ?

2406

Can I create users through internet explorer in oracle 10g?

1065

How do we create privileges in oracle?

1028

Explain the function of optimizer in oracle?

1103

How to see the table columns used in an index?

996

How to assign query results to variables?

1033

How to convert raw data type into text in oracle? Explain

976