CREATE TABLE `student` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
`city` varchar(40) NOT NULL,
`age` int(11) DEFAULT NULL
) ;
按照年龄段查询人数:
SELECT
nld AS '年龄段',
count(*) AS '人数'
FROM
(
SELECT
CASE
WHEN age >= 11
AND age <= 20 THEN
'11-20'
WHEN age >= 21
AND age <= 30 THEN
'21-30'
END AS nld
FROM
student
) a
GROUP BY
nld
查询结果: