find out the third highest salary?
Answer Posted / vanaja
select * from emp5 where salary in(select min(salary) from
emp5 where salary in(select top 3 salary from emp5 order by
salary desc))
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is SQL Tuning Advisor in Oracle?
What are the differences between date and timestamp in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What are named parameters?
How to write a query with a left outer join in oracle?
What is recovery manager in Oracle?
How index is implemented in oracle database?
What is meant by recursive hints in oracle?
How to execute a stored procedure in oracle?
What are advantages of dateset in datastage?
how to handle exceptions in post production
what is Single Byte Overhead...?
How data locks are respected in oracle?
What is the data pump export utility?
What is a read only transaction in oracle?