find out the third highest salary?
Answer Posted / harikrishna ravipati
select max(sal) from emp where sal <
(select max(sal) from emp where sal <
(select max(sal) from emp))
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use subqueries with the in operator using oracle?
What is a tns service name?
What is oracle join syntax?
Whether any commands are used for months calculation? If so, what are they?
List out the difference between commit, rollback, and savepoint?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How will you identify oracle database software release?
What is index in Oracle?
What is oracle rowcount?
How to define default values for formal parameters?
How to start your 10g xe server from command line?
Explain a synonym?
What is a nvl function?
What the is the diff between local index and global index. give some example.
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?