select a,sal from (select dense_rank() over (order by sal desc) a,sal fro

find out the third highest salary?

Question Posted / karunakar varma

Answer Posted / karunakar varma

select a,sal from (select dense_rank() over (order by sal
desc) a,sal from emp) where a=3

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what is the scenario where you take the database to NoArchivelog mode?

2259

What are the oracle differences between nvl and coalesce

1069

How can Oracle users be audited?

1056

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2191

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2902

Explain oracle left join with an example?

956

Â What are the oracle DML commands possible through an update strategy?

1006

What is an oracle database?

991

How to check the server version in oracle?

1035

What are the different editions of oracle?

1050

What is oracle in java?

913

what are steps for interface? where is exchange rate defined in which table?

2058

Explain the use of ignore option in imp command.

977

What are the different windows events activated at runtime ?

2834

Explain what are the advantages of views?

1014