CODEWITHSUNDEEP
sqlite
Skorpion
Skorpion

Reputation: 31

Sqlite select different rows as one

I've been searching the page for possible solutions but I can't find it anywhere.. What I need is pretty simple I need multiple rows to be displayed into one. I have tried || + ||, etc.

select c_category_in, c_data_services, c_dispositivos, c_averia as 'Sub-Category', count() as 'Total'
from tickets
group by c_category_in,c_averia,c_data_services,c_dispositivos 
having (Total > 1)

screenshot

Upvotes: 0

Views: 89

Answers (2)

andr
andr

Reputation: 16054

Based on your comments I would recommend taking a UNION of two separate groupings:

  1. Grouping the data by c_data_services
  2. Grouping the data by c_dispositivos

This results in a SELECT as following:

select c_category_in, c_data_services as 'Sub-Category', count() as 'Total'
from tickets
group by c_category_in, c_data_services
having (Total > 1)
union all
select c_category_in, c_dispositivos as 'Sub-Category', count() as 'Total'
from tickets
group by c_category_in, c_dispositivos
having (Total > 1)

Upvotes: 1

CL.
CL.

Reputation: 180020

The COALESCE function returns the first non-NULL value:

SELECT c_category_in,
       COALESCE(c_data_services, c_dispositivos) AS SubCategory,
       COUNT(*) AS Total
FROM tickets
GROUP BY c_category_in, SubCategory
HAVING Total > 1

Upvotes: 0

Related Questions