MYSQL: query to combine count

Question

the sql:

SELECT 
id, COUNT(id) AS Counter
FROM tableA  
GROUP BY id

the result:

enter image description here

the goal is to do like below:

enter image description here

to combine the (NULL ID) with ID=09 so that it will 0+1=1, give proper naming to the id will be great too, like

ID             Counter
NULLWITH09        1
THE 01           467
THE 02            8

any help would be great.. thanks

LoztInSpace · Accepted Answer · 2015-07-03 02:59:36Z

1

untested, but something like this:

SELECT 
'THE ' +id, COUNT(id) AS Counter
FROM tableA
where id is not null and id<>9  
GROUP BY id
UNION ALL
SELECT 
'null and 9', COUNT(*) AS Counter
FROM tableA
where id is null or id=9

answered Jul 3, 2015 at 2:59

LoztInSpace

5,6971 gold badge17 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

MYSQL: query to combine count

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related