find out the third highest salary?
Answer Posted / sabapathi
select sal from employee
where sal=(select min(sal) from employee
where sal>(select min(sal) from employee
where sal>(select min(sal) from employee)))
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain what are the different type of segments?
How to convert characters to times in oracle?
What are the set operators union, union all, minus & intersect meant to do?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
Explain the difference between a procedure and a function? What do you understand by those terms?
What are advantages of dateset in datastage?
How to retrieve the count of updated rows?
What is a dead lock in oracle?
How to pass a cursor variable to a procedure?
What is a subquery?
What do you mean by merge in oracle and how can you merge two tables?
How many file formats are supported to export data?
How to create a temporary table in oracle?
how to make an oracle object
How do I connect to oracle database?