不同范围的数据个数，如何做查询

gurenhua

新手求教:我有个表，如图。，希望建立个查询，得到为
<0.4   XXX个
>0.4 and <0.45 XXX个
>0.45  xx个的效果，该怎么做啊？

请帮助下，谢谢了！

aslxt

例如：
SELECT 表达式1 AS 数据期间,COUNT(表达式1) AS 数据个数 FROM
(SELECT 表6.时间, 表6.数量, IIf([数量]>=0.9,">=0.9",IIf([数量]>=0.7,">=0.7",IIf([数量]>=0.4,">=0.4",IIf([数量]>=0.2,">=0.2","<0.2")))) AS 表达式1
FROM 表6)
GROUP BY 表达式1 ;

todaynew

select iif(tave<0.4,"<0.4",iif(tave>=0.4 and tave<0.45,">=0.4 and <0.45",">0.45")) as 项目,count(项目) as 计数
from tbname
group by iif(tave<0.4,"<0.4",iif(tave>=0.4 and tave<0.45,">=0.4 and <0.45",">0.45"))