Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / karthik
select distinct sal from emp a where 2 = (select count
(distinct sal) from emp b where a.sal <= b.sal)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is procedure overloading in oracle?
What happens to the current transaction if a ddl statement is executed?
How to assign values to data fields in record variables?
what are bitmap indexes? How does they work?
How can we find out the duplicate values in an oracle table?
How much memory your 10g xe server is using?
How to create a new table by selecting rows from another table?
Is truncate autocommit in oracle?
What is index-organized table in Oracle?
please explain.. DB architecture ...
How a tablespace is related to data files?
What is a subquery?
What is a sub query? What are its various types?
Explain the use of ignore option in imp command.
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.
