请知道的来帮助解决一下这个问题啊?
loulanlouzhu的原题如下:place PKID zongcai ShiJianb 2 综采二对 22
e 5 综采二对 55
h 8 综采二对 88
c 3 综采三对 11
f 6 综采三对 66
i 9 综采三对 99
a 1 综采一对 33
d 4 综采一对 44
g 7 综采一对 77 -->>想得到:
place PKID zongcai ShiJianSum
b 2 综采二对 22
e 5 综采二对 55
h 8 综采二对 88
place ALL 综采二对 165
c 3 综采三对 11
f 6 综采三对 66
i 9 综采三对 99
place ALL 综采三对 176
a 1 综采一对 33
d 4 综采一对 44
g 7 综采一对 77
place ALL 综采一对 154
place ALL ALL 495 大力给的答案select place,pkid,zongcai,ShiJianSum from (
select place ,cast(PKID as varchar(10)) pkid, zongcai, ShiJian ShiJianSum,zongcai flag1,0 flag2 from tbl
union all
select 'place' ,'all', zongcai, sum(ShiJian),zongcai,1 from tbl group by zongcai
union all
select 'place' ,'all', 'all',sum(ShiJian),'zzzzzzzz',null from tbl) tem order by flag1,flag2
====>Just Seeing Hearing Saying Waiting Loving<====
~ ~ ~ ~ ~ ~
解决方案 »
- 急~~触发器更新数据问题
- 数据库存储图片和VB如何将图片调用到窗体的问题....大家帮忙看下...
- 我想在本机上设置sql邮件服务,可以绕开exchange server么?
- 怎样创建一个可以返回结果集的存储过程?
- 休息日与放假日同一天,要调整休息日。。。在线等。。。
- 急。。。alter table person drop primary key怎么不行?
- 如何控制执行存储过程的CPU占用率?
- 求站内搜索内容代码,按照搜索栏内的选项进行搜索,分别为内容,标题,数据库中的字段为count,title,我的数据库是sql2000,帮帮忙,给个搜索代码,深表感谢!!
- 我在win2000下启动ms sql数据库 打开数据表返回所有行的时候,报没有注册类别。。。
- sql的功能是不是太弱了﹐能不能幫我搞定這几個問題
- 怎么创建这样的视图?
- 如何将数据从远程导入?
select place ,cast(PKID as varchar(10)) pkid, zongcai, ShiJian ShiJianSum,zongcai flag1,0 flag2 where date between @date1 and @date2 from tbl
union all
select 'place' ,'all', zongcai, sum(ShiJian),zongcai,1 from tbl where date between @date1 and @date2 group by zongcai
union all
select 'place' ,'all', 'all',sum(ShiJian),'zzzzzzzz',null from tbl) tem where date between @date1 and @date2 order by flag1,flag2
====>Just Seeing Hearing Saying Waitting Loving<====
set @date1 = 3
set @date2 = 5
select place,pkid,zongcai,ShiJianSum from (
select place ,cast(PKID as varchar(10)) pkid, zongcai, ShiJian ShiJianSum,zongcai flag1,0 flag2 from TestHuiZong where pkid between @date1 and @date2
union all
select 'place' ,null, zongcai, sum(ShiJian),zongcai,1 from TestHuiZong where pkid between @date1 and @date2 group by zongcai
union all
select 'place' ,null, 'all',sum(ShiJian),'zzzzzzzz',null from TestHuiZong where pkid between @date1 and @date2) tem order by flag1,flag2
select place ,cast(PKID as varchar(10)) pkid, zongcai, ShiJian ShiJianSum,zongcai flag1,0 flag2 where date between '这里写时间呀' and '这里写时间呀' from tbl
union all
select 'place' ,'all', zongcai, sum(ShiJian),zongcai,1 from tbl where date between '这里写时间呀' and '这里写时间呀' group by zongcai
union all
select 'place' ,'all', 'all',sum(ShiJian),'zzzzzzzz',null from tbl) tem where date between '这里写时间呀' and '这里写时间呀' order by flag1,flag2