Is it possible to change the result only if there's more than one?

My query brings this result:

If I have only one produt, that's fine.

But if I have more than one, it shows like this:

The question is: Is it possible to change values only if I have more than one produt in my query?

Something like this; if I have products A and B, it should show:

CodePudding user response：

You can use case expressions, looking at the count of (optionally distinct) values in each column; for example:

select some_date,
  case when count(distinct code) > 1
       then 'Various'
       else to_char(max(code))
  end as code,
  case when count(distinct description) > 1
       then 'Various'
       else max(description)
  end as description,
  sum(amount) as amount
from your_table
group by some_date
order by some_date;

db<>fiddle