select bzirk,spart,sum(zzfkimg)
from s901
where sptag = '20041010'
group by grouping sets((spart),(bzirk));
各位高手:如上为sql语句,实在不明白这个grouping sets哪里出错了?谢谢指点迷津!
from s901
where sptag = '20041010'
group by grouping sets((spart),(bzirk));
各位高手:如上为sql语句,实在不明白这个grouping sets哪里出错了?谢谢指点迷津!
报什么错?根据错误提示可以调试下..
/* Formatted on 2009/11/13 22:54 (Formatter Plus v4.8.8) */
SELECT ename, deptno, SUM (sal)
FROM scott.emp
WHERE deptno = 10
GROUP BY GROUPING SETS ((deptno), (ename));
2 from s901
3 where sptag = '20041010'
4 group by grouping sets((spart),(bzirk));
group by grouping sets((spart),(bzirk))
*
ERROR at line 4:
ORA-00933: SQL command not properly ended如上为报错信息,谢谢了情帮忙看看有什么问题。