基于值的SQL查询的结果计数 [英] Count of result of a sql query based on values

问题描述

sql中临时表的结果如下：

The result of a temp table in sql is like:

ServiceType
-----------
E                             
I                             
I                             
E                             
I                             
D                             
I 
D
E

我希望上面结果的计数类似这样（其中I-Imp，E-Exp，D- Dom）：

I want the count of above result something like this (where I-Imp,E-Exp,D-Dom):

Type   Count
------------
Exp     3
Imp     4
Dom     2      

任何人都可以建议我最好的方法实现这个？

Can anyone please suggest me the best way to achieve this? I am trying to do this by creating an other temp table.

推荐答案

您可以尝试这样：

SELECT CASE ServiceType 
       WHEN 'I' THEN 'Imp' 
       WHEN 'E' THEN 'Exp' 
       WHEN 'D' THEN 'Dom' END AS Type
, COUNT(ServiceType) AS `Count`
FROM MyTable GROUP BY ServiceType

结果：

| TYPE | COUNT |
----------------
|  Dom |     2 |
|  Exp |     3 |
|  Imp |     4 |

这篇关于基于值的SQL查询的结果计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！