dont use COMPUTE , use ROLLUP.SELECT
(case grouping(type) WHEN 0 then type ELSE '合计') as type
, sum(price) as sum_price
, sum(num) as sum_num
FROM titles
GROUP BY type WITH ROLLUP
ORDER BY grouping(type) , type
(case grouping(type) WHEN 0 then type ELSE '合计') as type
, sum(price) as sum_price
, sum(num) as sum_num
FROM titles
GROUP BY type WITH ROLLUP
ORDER BY grouping(type) , type
解决方案 »
- COM+远程组件如何打包安装?客户端又怎么打包安装?
- 关于线程的奇怪问题
- 如何用Delphi写OCX控件???
- 我想做一个互联网上传输数据的程序,谁来帮帮忙啊?
- 在线急需,请各位给想想办法
- 线程里的变量锁定问题
- 如果我知道一台SQL2000服务器的IP地址、用户名和密码,我应该怎么连到这台服务器上啊?
- ????????渴望高手救助
- 请问能否把table的第一个字段(A)的属性设为readonly,不能修改,而第二个字段能够edit呢?如何弄呢?
- 急急急!!!数据模块的使用,碰到无法解决的问题,请帮帮忙。。。
- 后天到某软件公司面试,大家帮我,他们会出什么样的面试题?
- access无法从表2中复制数据到表1中去(用sql)
(case grouping(type) //判断变量的值
WHEN 0 then type //0的情况
ELSE '合计') //否则
as type //别名 显示用
, sum(price) as sum_price //求和
, sum(num) as sum_num
FROM titles
GROUP BY type WITH ROLLUP
ORDER BY grouping(type) , type
我前台一般只用三句话:
quickrep1.preview;form1.Show;
form1.QRPreview1.QRPrinter:=quickrep1.QRPrinter;