希望将该语句转化为标准sql

[blackhawk_yps]

前不久我提问了一个统计的sql语句。见：
http://expert.csdn.net/Expert/topic/1224/1224717.xml?temp=.6220667
为了将来数据库移植的方便，想把该语句转化成标准sql，希望得到大家的帮助。

SELECT case when(grouping(type)=1) then 'all' else isnull(type,'unknown') end as type,
SUM(CASE WHEN pagesize='c1' THEN 1 ELSE 0 END) AS size1,
SUM(CASE WHEN pagesize='c2' THEN 1 ELSE 0 END) AS size2,
SUM(CASE WHEN pagesize='c3' THEN 1 ELSE 0 END) AS size3,
count(pagesize)
FROM test
WHERE prop='r1' or prop='r2' or prop='r3'
GROUP BY type,prop with rollup
having grouping(type)<>1

[蓝天]

寻求“放之四海皆准”的真理，难啊。

[crystal_heart]

前不久我提问了一个统计的sql语句。见：
http://expert.csdn.net/Expert/topic/1224/1224717.xml?temp=.6220667
为了将来数据库移植的方便，想把该语句转化成标准sql，希望得到大家的帮助。

SELECT case when(grouping(type)=1) then 'all' else isnull(type,'unknown') end as type,
SUM(CASE WHEN pagesize='c1' THEN 1 ELSE 0 END) AS size1,
SUM(CASE WHEN pagesize='c2' THEN 1 ELSE 0 END) AS size2,
SUM(CASE WHEN pagesize='c3' THEN 1 ELSE 0 END) AS size3,
count(pagesize)
FROM test
WHERE prop='r1' or prop='r2' or prop='r3'
GROUP BY type,prop with rollup
having grouping(type)<>1

[blackhawk_yps]

哈哈，谢谢！

[blackhawk_yps]

帮我解决http://expert.csdn.net/Expert/topic/1224/1224717.xml?temp=.6220667
的大虾们，你们在哪里呢？