SQL 对同一个字段,按不同值进行统计的方法
1 SELECT 2 COUNT(CASE WHEN 字段 LIKE '11%' THEN 1 END) AS name1, 3 COUNT(CASE WHEN 字段 LIKE '12%' THEN 1 END) AS name2, 4 COUNT(CASE WHEN 字段 LIKE '13%' THEN 1 END) AS name3 5 FROM 表名
SQL 对同一个字段,按不同值进行统计的方法
1 SELECT 2 COUNT(CASE WHEN 字段 LIKE '11%' THEN 1 END) AS name1, 3 COUNT(CASE WHEN 字段 LIKE '12%' THEN 1 END) AS name2, 4 COUNT(CASE WHEN 字段 LIKE '13%' THEN 1 END) AS name3 5 FROM 表名