1.-------------
select
(select count(*) from a where ...) as c1,
...
(select count(*) from a where ...) as cn
from dual;2.--------------
use decode
select
(select count(*) from a where ...) as c1,
...
(select count(*) from a where ...) as cn
from dual;2.--------------
use decode
use case
Exp:
select ...
case trunc(age/10) when .....
end ...
from table;
2.----------
use decode
Exp:
select ...
decode( trunc(age/10),...
...)
from table
select 字段 from a where <10
union
select 字段 from a where 10-20
union
select 字段 from a where 20-60
union
select 字段 from a where >=60
sum(decode(floor(age/10),1,1,0)) 10-20,
sum(decode(floor(age/10),1,1,2,1,3,1,4,1,5,1,0)) 20-60,
sum(decode(floor(age/10),6,1,0)) ">=60"
from a