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 tns service name?
How can we find out the duplicate values in an oracle table?
how may join possible between (requisition with purchase order)
What is an oracle database table?
How to rename an index?
What is a proxy class?
How to filter out duplications in the returning rows using oracle?
Explain what are the different type of segments?
what is insert all statement in sql
How to change system global area (sga) in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How do you bind variables in oracle?
How to grant create session privilege to a user in oracle?
Explain the blob datatype?
What to do if the binary spfile is wrong for the default instance?