find out the third highest salary?
Answer Posted / alka
select min(salary)
from(select salary
from emp
order by salary desc
)
where rownum <=3
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What is program global area (pga) in oracle?
What is the relation of a user account and a schema?
How to drop an existing view in oracle?
How to assign values to variables?
What is the difference between alert log file and tarce file ?
What are oracle functions?
Explain the use of full option in exp command.
material view and view disadvantages?
can u plz provide me oca sql dumps please i need them
How to create tables for odbc connection testing?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
Is the After report trigger fired if the report execution fails ?
How to use "while" statements 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.
How to test null values?