Oracle横向纵向汇总
1 select decode(grouping(name),1,‘总分‘,name) 姓名, 2 sum(decode(km, ‘数学‘,cj,0)) 数学, 3 sum(decode(km, ‘英语‘,cj,0)) 英语, 4 sum(decode(km, ‘语文‘,cj,0)) 语文, 5 sum(cj) 总成绩 6 from test group by rollup(name)
原文：http://www.cnblogs.com/wqsbk/p/4939079.html