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
Answer / rameshganesan
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 a view be updated?
Â How to use an oracle sequence generator in a mapping?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
what are indexes..how many types of index's are there and what are they?
which is best insttute for teradata,sybase,mysql,oracle in hyderabad
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
State some uses of redo log files?
What are the ways tablespaces can be managed and how do they differ?
Why we choose emp number as primarykey?
What is analyze command used for?
What is the exact use of Collections?