sql - Access 中的组值范围

Question

我有一张表可以 Access 这些:

Name:-----Birthdate:-----Section----etc...
John------10/10/1985-----etc...  
Mike------02/03/1976-----etc...  

还有更多。

我怎样做一个 sql 查询来获取表中的人的年龄，计算它并显示范围？

类似于:

Group1 ( From 18 to 25 ): 2 people  
Group2 ( From 26 to 35 ): 1 person  
...

感谢您的回答!

Answer 1

您可以使用 datediff 计算某人的年龄:

datediff('yyyy', Birthdate, now())

A switch应该允许您按范围分组:

select  AgeGroup            
,       count(*)
from    (
        select  switch(
                  datediff('yyyy', Birthdate, now()) between 18 and 25, '18 to 25',
                  datediff('yyyy', Birthdate, now()) between 26 and 35,  '26 to 35',
                  true, 'other') as AgeGroup 
        from    YourTable
        ) as SubQueriesMustBeNamed
group by 
        AgeGroup