select a.max1+b.max1 as maxsum,a.itemsum+b.itemsum as itemsum from
(select max(value) as max1,0 as itemsum from tablename) a,
(select 0 as max1,count(*) as itemsum from tablename where value>5) b
(select max(value) as max1,0 as itemsum from tablename) a,
(select 0 as max1,count(*) as itemsum from tablename where value>5) b
from dual;
select max(value)
,sum(case when value>5 then 1 else 0 end)
from tmp
看看这句
select max(value),count(*) from (select * from tbname order by value desc) where value > 5
dinya2003(OK):能否详细说一下为何9i以下不好用。8i我知道是可以的,以下就没试过了。即使不支持case,decode应该支持吧,把case改成decode就可以了。