select * from ( select Name, Salary, Dept, Rank()over (ord

find out the third highest salary?

Question Posted / raghav

Answer Posted / raghav

select * from (
select Name,
Salary,
Dept,
Rank()over (order by salary desc) RANK
from Employee)
where RANK = 3

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to create a new table in oracle?

1165

How do I find my oracle client driver version?

1048

What are the differences between char and nchar in oracle?

1101

What is logical backup in oracle?

1025

Why does Oracle not permit the use of PCTUSED with indexes?

2428

What is ordinary table in oracle?

1166

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2126

Explain constraining triggers.

1103

How to delete an existing row from a table in oracle?

1074

How to count duplicated values in a column in oracle?

1052

What is connection pool in oracle?

993

What is an external table?

1032

Explain rename?

988

types of indexes and the rationale behind choosing a particular index for a situation.

2514

Explain a synonym?

1035