Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
Answer Posted / suresh
45000
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is ASM (Automatic Storage Management) in Oracle?
Difference between the “verify” and “feedback” command?
How to check your oracle database 10g xe installation?
How to insert a record into a table?
What is a trace file and how is it created in oracle?
What is a cognitive schema?
Is it possible to insert comments into sql statements return in the data model editor ?
How to convert characters to times in oracle?
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 create a table in a specific tablespace?
How to drop a stored function?
 What are the oracle DML commands possible through an update strategy?
How to run queries on external tables?
Whats the benefit of dbms_stats over analyze?
What is the difference between primary key and unique key and foreign key in oracle?