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 2
NULL 3 4
NULL 5 6
7 NULL NULL
O/P
C
=
2
4
6
- 2 Answers
- 3931 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rameshganesan
Select (Case
When a = Least Then (select 'A'||CHR(10)||'='||CHR(10)||ListAgg(a,CHR(10)) Within Group(order by a) from Least_Col)
When b =Least Then (select 'B'||CHR(10)||'='||CHR(10)||ListAgg(b,CHR(10)) Within Group(order by b) from Least_Col)
Else (select 'C'||CHR(10)|| '='||CHR(10)||ListAgg(c,CHR(10)) 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 ? | 1 Yes | 0 No |
How to delete all rows a table in oracle?
Tell me New Feature of Oracle 10g?
Explain compound trigger in oracle?
Can a Tablespace hold objects from different Schemes ?
How to export data to a csv file?
Explain what are the advantages of views?
Describe Referential Integrity ?
What is truncate oracle?
Write query to fetch second maximum salary from employee table.
4 Answers Bravura Solutions, HCL,
What exactly do quotation marks around the table name do?
How would you best determine why your MVIEW couldnt FAST REFRESH?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Oracle General 
