1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.
- 6 Answers
- 6888 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
select top(1) sal From sample
where sal
in (select top(2) salfrom sample order by saldesc)
order by sal asc
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Where do we use decode and case statements?
What is the sid in oracle?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What is data file?
what is dynamic SGA and static SGA
How to end the current transaction in oracle?
What is the dynamic sql in oracle?
What is java oracle used for?
What privilege is needed for a user to delete rows from tables in another schema?
What is ASM (Automatic Storage Management) in Oracle?
Please explain oracle data types with examples?
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.
how to handle exceptions in post production
What is the data type of dual table?
