This will give you third highest salary select ename, sal from (Select

Find out the 3rd highest salary?

Question Posted / srijith pillai

Answer Posted / srijith pillai

This will give you third highest salary

select ename, sal from
(Select name, sal, rownum()Over(Order by sal Desc) rt
FROM emp)
where rt = 3;

Is This Answer Correct ?

13 Yes

19 No

Please Help Members By Posting Answers For Below Questions

What is difference between hql and sql?

1055

Can a composite key be null?

963

What does select top 1 do in sql?

1077

How do you exit in sql?

1096

give the syntax of grant and revoke commands? : Sql dba

1140

How does sql developer connect to oracle database?

986

Explain 3 basic parts of a trigger.

1300

Why truncate is used in sql?

985

what is msql? : Sql dba

971

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

944

Why do we use procedures in pl sql?

1011

What is function and procedure?

1019

What does sql stand for?

978

What are all the different normalization?

1027

What is schema in sql example?

1160