9i下可以这么写,age是你的年龄表达式,后面不用group by 了 select sum( case when age <= 35 then 1 else 0 end ) "<35", sum( case when age > 35 and age <=45 then 1 else 0 end ) "35-45", sum( case when age > 45 and age <=55 then 1 else 0 end ) "45-55", sum( case when age >55 then 1 else 0 end ) "35-45" from personbase
select sum( case when age <= 35 then 1 else 0 end ) "<35",
sum( case when age > 35 and age <=45 then 1 else 0 end ) "35-45",
sum( case when age > 45 and age <=55 then 1 else 0 end ) "45-55",
sum( case when age >55 then 1 else 0 end ) "35-45"
from personbase