如果我想要查询用户分组年龄的计数
要获取每年的计数,请执行以下操作:
select count(*)
from tbl_user
group by age 例如,我如何创建一个自定义的分组依据,以便我可以获取范围内的年龄。如下例所示:
group by ages as 0-18 , 19-25 , 26-...发布于 2012-07-11 22:50:29
1和大小写在MS SQL Server中工作时,您使用的是哪个版本的SQL?
SELECT
SUM(CASE WHEN Age >= 0 AND Age <= 18 THEN 1 ELSE 0 END) AS [0-18],
SUM(CASE WHEN Age >= 19 AND Age <= 25 THEN 1 ELSE 0 END) AS [19-25]
FROM
YourTable发布于 2012-07-11 22:52:59
在子查询中使用CASE表达式,并在外部查询中按该表达式分组:
select age_group, count(*)
from (
select case when age between 0 and 18 then '0-18'
when age between 19 and 26 then '19-25'
...
end as age_group
from tbl_user
) t
group by age_group发布于 2012-07-11 22:53:48
您可以使用CASE语句:
SELECT Sum(CASE WHEN age BETWEEN 0 AND 18 THEN 1 ELSE 0 END) as [0-18],
Sum(CASE WHEN age BETWEEN 19 AND 25 THEN 1 ELSE 0 END) as [19-25],
Sum(CASE WHEN age BETWEEN 26 AND 34 THEN 1 ELSE 0 END) as [26-34]
FROM tbl_user这会将数据“扁平化”成一行--要使每个分组都有一行,请使用它作为View的基础,然后从中进行选择。
https://stackoverflow.com/questions/11435231
复制相似问题