Select (Case When a = Least Then (select 'O/P A ='|

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

Question Posted / rameshganesan

1 Answers
3360 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How remove data files before opening a database?

1074

Why oracle is used?

1058

How can we delete duplicate rows in a table?

973

How to export data to a csv file?

1306

What happens to the current transaction if a ddl statement is executed?

1013

How will you write a query to get a 5th rank student from a table student_report?

1866

Can we create trigger on materialized view in oracle?

992

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2103

Why does oracle 9i treat an empty string as null?

1056

Explain the characteristics of oracle dba?

1120

What are transaction isolation levels supported by oracle?

1072

How to rename an existing table?

1129

What is raw datatype?

1136

What is tns entry?

1151

what is the difference between data migration and production migration.

2346