SELECT age_temp,COUNT(*) AS total FROM (
SELECT age,
CASE
WHEN age BETWEEN 10 AND 20 THEN '10-20'
WHEN age BETWEEN 20 AND 30 THEN '20-30'
END AS age_temp
FROM t_user
)AS USER GROUP BY age_temp;
利用sql语句统计各年龄段的数量
最新推荐文章于 2024-06-14 13:50:00 发布