Find out the 3rd highest salary?
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 |
Post New Answer View All Answers
What is difference between hql and sql?
Can a composite key be null?
What does select top 1 do in sql?
How do you exit in sql?
give the syntax of grant and revoke commands? : Sql dba
How does sql developer connect to oracle database?
Explain 3 basic parts of a trigger.
Why truncate is used in sql?
what is msql? : Sql dba
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
Why do we use procedures in pl sql?
What is function and procedure?
What does sql stand for?
What are all the different normalization?
What is schema in sql example?