在SQL Server 2000上,投票率最高的两个答案都不正确.也许他们使用的是不同的版本.
以下是SQL Server 2000上这两个版本的正确版本.
select t.range as [sc或e range], count(*) as [number of occurences]
from (
select case
when sc或e between 0 and 9 then ' 0- 9'
when sc或e between 10 and 19 then '10-19'
else '20-99' end as range
from sc或es) t
group by t.range
或
select t.range as [sc或e range], count(*) as [number of occurrences]
from (
select user_id,
case when sc或e >= 0 and sc或e< 10 then '0-9'
when sc或e >= 10 and sc或e< 20 then '10-19'
else '20-99' end as range
from sc或es) t
group by t.range