find out the second highest salary?
Answer Posted / mallikarjun
select max(sal) from emp
where sal < select max (sal)from emp
Mallikarjun
| Is This Answer Correct ? | 216 Yes | 86 No |
Post New Answer View All Answers
Why do we need oracle client?
Does facebook use oracle?
Explain the types of exception?
How to import one table back from a dump file?
Is a rollback possible to any savepoint?
Explain an integrity constrains?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to manage transaction isolation level?
What is a proxy object?
How to load excel data sheet to oracle database
Can you have more than one content canvas view attached with a window ?
What privilege is needed for a user to query tables in another schema?
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 is meant by recursive hints in oracle?
How to check the oracle tns settings?