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 delete all rows a table in oracle?

1068

Explain overloading. Can functions be overloaded?

986

What is a cursor in oracle?

1172

Can we save images in a database and if yes, how?

1063

What is the usage of synonyms?

1139

How do we get field detail of a table?

1077

candidate key is subset of super key but not vice-verse explain

2068

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2497

How to count groups returned with the group by clause in oracle?

1075

What is the difference between translate and replace in oracle?

1163

Explain the use of show option in imp command.

1096

What is merge statement used for?

1024

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2041

What are the attributes of cursor?

1049

What is a relational database management system?

1120