find out the third highest salary?
Answer Posted / amit sutar
select min(salary)
from(select distinct(salary)
from employees
order by salary desc)
where rownum<=5;
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
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 can you use check constraints for self referential integrity?
What is a Garbage Collection? and what is full recursive Garbage collection?
What is an oracle tablespace?
How to open and close an explicit cursor in oracle?
How to set up autotrace for a user account?
How to change user password in oracle?
State the various uses of dbcc command?
How to get a list of all user accounts in the database?
What is oracle host variable?
When system tablespace is created?
What are the differences between primary key and unique key?
Explain the use of rows option in exp command.
How do I limit the number of oracle database connections generated by weblogic server?
What are ddl statements in oracle?