MYSQL:查询合并计数

Question

sql:

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

结果:

目标是执行以下操作:

将 (NULL ID) 与 ID=09 组合起来，这样它就会 0+1=1，给 id 适当的命名也很好，就像

ID             Counter
NULLWITH09        1
THE 01           467
THE 02            8

任何帮助都会很棒..谢谢

Answer 1

未经测试，但类似这样:

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