select '女' sex, sum(decode(sex,'女',1,0)) count from tb union all select '男' sex, sum(decode(sex,'男',1,0)) count from tb
SELECT sex, SUM((CASE WHEN sex='男' THEN 1 WHEN sex='女' THEN 1 ELSE 0 END))"count" FROM t_name GROUP BY sex
T_T,我要用的是case when啊,因为这个例子是我简化了的,实际的是需要根据当前时间,每个多少秒来分组统计的,所以一定需要用到case when
SELECT '男' "sex", SUM((CASE WHEN sex='男' THEN 1 ELSE 0 END))"count" FROM t_name UNION SELECT '女' "sex", SUM((CASE WHEN sex='女' THEN 1 ELSE 0 END))"count" FROM t_name
union all
select '男' sex, sum(decode(sex,'男',1,0)) count from tb
SELECT sex, SUM((CASE WHEN sex='男' THEN 1 WHEN sex='女' THEN 1 ELSE 0 END))"count"
FROM t_name
GROUP BY sex
SELECT '男' "sex", SUM((CASE WHEN sex='男' THEN 1 ELSE 0 END))"count"
FROM t_name
UNION
SELECT '女' "sex", SUM((CASE WHEN sex='女' THEN 1 ELSE 0 END))"count"
FROM t_name