Fetch not null values in one column oracle

Question

Below is my query

SELECT * FROM companystatus where company_name='Fifth Borrower' ;

I want the not null values in single row for one borrower.

Expected output

Littlefoot · Accepted Answer · 2020-08-25 05:11:08Z

1

Aggregation usually helps in such requirements, e.g.

select 
  company_code,
  company_name,
  max(c2015),
  max(c2016),
  max(c2017)
from companystatus
where company_name = 'Fifth Borrower'
group by company_code,
         company_name

answered Aug 25, 2020 at 5:11

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Anurag Yadav Over a year ago

Thanks, is there anyway to select my columns as column name present in the table are integer?

Littlefoot Over a year ago

In Oracle, a column name can't begin with a digit unless you enclose its name into double quotes. In my opinion, that's a bad idea. That's why I presumed that real column names aren't 2015, 2016, etc.

Collectives™ on Stack Overflow

Fetch not null values in one column oracle

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related