find out the third highest salary?
Answer Posted / joel
select sal from emp
where sal<(select max(sal) from emp
where sal in (select sal from emp
where sal < ( select max(sal) from emp)))
Is This Answer Correct ? | 6 Yes | 8 No |
Post New Answer View All Answers
What is the meaning of recursive hints in oracle?
Explain what are synonyms used for?
Can multiple columns be used in group by in oracle?
Why do we use bulk collect in oracle?
How different is ms access and oracle?
What is an external table?
What are the major difference between truncate and delete?
What are the common oracle dba tasks?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to rebuild an index in oracle?
Where is the export dump file located?
Which environment variables are absolutely critical in order to run the OUI?
Explain the importance of .pll extension in oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What is a user role in oracle?