sql - Create CASE WHEN labels based on DISTINCT values in a particular column

Question

Closed. This question needs details or clarity. It is not currently accepting answers. question from:https://stackoverflow.com/questions/65918143/create-case-when-labels-based-on-distinct-values-in-a-particular-column

Answer 1

Hmmm . . . How about this?

select id,
       (case when min(category) = max(category)
             then min(category) || ' only'
             when count(distinct category) = 3
             then 'All'
             when min(category) is NULL
             then 'None'
             else min(category) || ' and ' || max(category)
        end)
from t
group by id;