用WITH ROLLUP将上面的语句改为:
SELECT A,SUM(B),SUM(C)
FROM TABEL1
group by a WITH ROLLUP
SELECT A,SUM(B),SUM(C)
FROM TABEL1
group by a WITH ROLLUP
解决方案 »
- 啥子版本哦,连日志和导入导出向导都没的
- 关于数据查询时的"超时已过期"的问题
- 菜鸟求救,sql问题
- 创建外键又不检查现有数据的sql语句怎么写?
- 如何更好提高SQL2000的内存使用率
- 视图里面能够有条件判断吗,详情请进 ???????????
- 数据库分布式系统
- sql2000的怪问题!究竟sql那里设的东西被改了?在线等待!焦急!!
- 100分请助!!谁有《SQL Server 2000中文版彻底研究》的电子书下载!!!
- 一个非常菜鸟的问题-------怎样使asp.net对sql server访问!
- 如何写这样的一个触发器或存储过程?
- 关于 Cascade 循环 或者 多条 Cascade 路径的 错误!
insert into 你的表
SELECT A,SUM(B),SUM(C)
FROM TABEL1
group by a WITH ROLLUP
insert into TABEL2 (字段1,字段2,字段3) select A as 字段1,sum(B) as 字段2,sum(C) as 字段3 from TABEL1 group by A order by A
insert into table2 from select A,sum(B),sum(C) from table1 order by A comoute sum(B),sum(C) by A
如果另一个表不存在的话:
select A,sum(B),sum(C) into table2 from table1 order by A comoute sum(B),sum(C) by A
请不要随便说有点难,这里高手大把的(除我以外)
select left(a,2) a,sum(b) b,sum(c) c from table1 group by left(a,2)
union all
select left(a,4),sum(b),sum(c) from table1 where len(a)>=4 group by left(a,4)
union all
select left(a,6),sum(b),sum(c) from table1 where len(a)>=6 group by left(a,6)
union all
select left(a,10),sum(b),sum(c) from table1 where len(a)>=10 group by left(a,10)) tem order by a