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

How to use attributes of the implicit cursor in oracle?

1008

How to load data through external tables?

1135

What are the original export and import utilities?

1166

What is an oracle wallet?

942

What are the differences between date and timestamp in oracle?

1044

What is the use of oracle?

1027

Explain rename?

976

How to drop an index in oracle?

1074

How to upsert (update or insert into a table)?

997

What do you mean by a deadlock?

1061

How index is implemented in oracle database?

1005

How to drop an existing view in oracle?

942

How to connect ms access to oracle servers?

1005

Whats the benefit of dbms_stats over analyze?

1999

What is an oracle user role?

984