1.使用group by
select count(*),‘列名’ from tablename group by ‘列名’
2.使用sum和group by结合
select name,
sum(case when status=2 then 1 else 0 end ),
sum(case when status<>2 then 1 else 0 end )
from table
group by name
SELECT
COUNT(*) AS 总数,
SUM(CASE WHEN create_time < ‘2018-01-01 00:00:00’ THEN 1 ELSE 0 END) AS 年前数据总量,
SUM(CASE WHEN create_time > ‘2018-01-01 00:00:00’ THEN 1 ELSE 0 END) AS 年后数据总量,
FROM