find out the third highest salary?
Answer Posted / mamta
select rownum as maxsal,sal
from (select sal from emp order by sal desc)
where rownum <4
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Can sub procedure/function be called recursively?
What is a table in oracle?
What are the advantages of oracle?
Is insert autocommit in oracle?
What is rich query?
What is snapshot is too old? Give and example for better understand.
What is a user role in oracle?
How to execute the package in oracle?
How to open and close an explicit cursor in oracle?
Why do you create or replace procedures rather that drop and recreate.
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What are advantages of dateset in datastage?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What is translate in oracle?
Can you have more than one content canvas view attached with a window ?