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
- 4048 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 |
What are the type of Synonyms?
How to Select second Maximum salary in a Table ?
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
In which language oracle has been developed?
How to use attributes of the implicit cursor in oracle?
what is difference between where clause and having clause?
what is IDE,DMV in sql server?
Why do we need integrity constraints in a database?
How to use null as conditions in oracle?
How to define a cusotmer as a supplier in ORACLE R12
Can objects of the same schema reside in different tablespace?
What do you mean by merge in oracle and how can you merge two tables?
Oracle General 
