求一分组统计 SELECT PRODUCT,COUNT(QUANTITY) AS 总数,COUNT(*) AS 累计总数FROM 表GROUP BY PRODUCT 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select produce, sum(QUANTITY) pro_sum,sum(sum(QUANTITY)) over(order by produce rows unbounded preceding) totalfrom aaaagroup by produce select produce, sum(QUANTITY) as 总数,sum(sum(QUANTITY)) over(order by produce rows unbounded preceding) as 累计总数from aaaagroup by produce to liuyi8903(西西) 可以解释一下这段话的意思吗?sum(sum(QUANTITY)) over(order by produce rows unbounded preceding) 楼主可以看看分析函数的资料http://www.akadia.com/services/ora_analytic_functions.html#Windows oracle文件tnsnames.ora 谁能给我一个oracle论坛的邀请码呀 如何把sql 的结果集返回给shell oracle取出某一段记录错误! vista下装不上oracle 9i? 求一个对表中记录分组的存储过程 关于oracle中计算列的问题!请教!! 大家帮帮忙啦!!! oracle里的date类型的数据格式是什么样的啊,我这样为什么错了 删除表空间的问题 高手们请问存储过程一般是在什么情况下用?谢谢 关于触发器的问题(在一个表中检索符合要求的数据累加起来放到另外一个表中)(请大侠帮忙,急急急)
sum(sum(QUANTITY)) over(order by produce rows unbounded preceding) total
from aaaa
group by produce
sum(sum(QUANTITY)) over(order by produce rows unbounded preceding) as 累计总数
from aaaa
group by produce
可以解释一下这段话的意思吗?
sum(sum(QUANTITY)) over(order by produce rows unbounded preceding)
http://www.akadia.com/services/ora_analytic_functions.html#Windows