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