select * from tablename where A='aaa'
解决方案 »
- 帮忙修改下存储过程
- 请问SQL2005查询分析器中的"显示结果窗格"按钮去哪里啦?
- 请教使用dts是否可以实现远程数据的增量传输并更新本地修改的数据?
- 绝对的需要高手,关于批量数据库A复制到数据库B的问题,求大神帮助
- 为什么min()没有返回最小值
- SQL2005,新手求助~~查询速度过慢,我应该怎么写SQL文
- 高手来帮我解决一个嵌套查询的问题,分只有这么多了,还望赐教
- 请教如何实现这样一个分类合计的过程。
- 请教高手,怎样用sql语句选出access数据库中的所有表名和表中的列名?
- 如何在更新一个记录的时候,实现如下的触发器功能
- 求判定数据重复的SQL语句
- 如何通过已经有的ldf和mdf文件创建一个新的数据库呢
bumen =
case
when grouping(bumen)=1 then '总计'
when grouping(bumen)=1 then '小计'
else bumen
end,
name,
gongzi=sum(gongzi)
from table1
group by bumen,name
with rollup
2.a1?没有这个字段
select * from (
select bumen name gongzi from tb1
union all
select bumen+'合计:',cast(count(name) as varchar) ,sum(gongzi)
from tb1) aa order by bumen
--2.
select * from tb where a='aaa'
select bumen,name,gongzi from tb1
union all
select bumen+'合计:',cast(count(name) as varchar) as name ,sum(gongzi) as gongzi
from tb1
group by bumen+'合计:'
order by bumen
--2.
select * from tb where a1='aaa'
insert into #A select 'zjb','zhangyi',1200
insert into #A select 'zjb','zhanger',2400
insert into #A select 'zjb','zhangsan',4200
insert into #A select 'scb','lisi',2200
insert into #A select 'scb','liliu',6000SELECT
CASE WHEN (GROUPING(bumen) = 1) THEN 'ALL'
ELSE ISNULL(bumen, 'UNKNOWN')
END AS bumen,
CASE WHEN (GROUPING(name) = 1) THEN 'HeJi'
ELSE ISNULL(name, 'UNKNOWN')
END AS name,
count(bumen) AS 'HeJi',SUM(gongzi) AS gongzi
FROM #A
GROUP BY bumen, name WITH ROLLUP然后在页面邦定自己需要的信息就可以啦
http://blog.csdn.net/zlp321002/archive/2005/10/09/498112.aspx
from zero
order by bumen
compute sum(gongzi) by bumen
compute sum(gongz)
from 表名
order by bumen
compute sum(gongzi) by bumen
compute sum(gongz)
else isnull(bumen,'找不到')
end as bumen,
case when grouping(name)='1' then '合计'
else isnull(name,'找不到')
end as name,
sum(gongzi) as 合计数
from testing03 group by bumen,name with rollup