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
- 3436 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 |
Can we create index on views?
19 Answers CTS, Syntel, TCS,
How to select some rows from a table in oracle?
What is the difference between sharding and replication?
11. Display the client number and name and the client number and name of the person who referred that client.
Explain oracle left join with an example?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
How to check database size in Oracle?
How many types of cluster table in Oracle?
How many types of synonyms in Oracle?
How to see free space of each tablespace?
Explain the use of control file?
write a query that displays every Friday in a year with date?
Oracle General 
