Interested to Buy Any Domain ? << Click Here >> for more details...
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT)
Write the query plz.
A B C
----------
1 NULL 7
2 4 NULL
NULL 5 NULL
3 NULL NULL
- 1 Answers
- 3368 Views
- TCS, I also Faced
- E-Mail Answers
Answer / rameshganesan
Select (Case
When a = Least Then (select 'O/P A ='||ListAgg(a,' ') Within Group(order by a) from Least_Col)
When b =Least Then (select 'O/P B ='||ListAgg(b,' ') Within Group(order by b) from Least_Col)
Else (select 'O/P C ='||ListAgg(c,' ') Within Group(order by c) from Least_Col) end)ab
From (Select count(a) a,count(b) b,count(c) c,greatest(count(a),count(b),count(c)) Least From Least_Col);
| Is This Answer Correct ? | 0 Yes | 0 No |
How to find out what privileges a user currently has in oracle?
Can I create users through internet explorer in oracle 10g?
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 use an explicit cursor without open statements?
What is indexing, and how does it improve performance?
Write a simple Store procedure and pass parameter to it ?
What is Database Link ?
How to define a cusotmer as a supplier in ORACLE R12
what is the difference between sql& oracle?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
How does one get the view definition of fixed views/tables?
Oracle General 
