解决方案 »
- asp.net excel 2007导入报错 System.Data.OleDb.OleDbException: External table
- 关于gridview列表以及多条件查询?
- 基础问题:要网页中的字体凡是汉字都是宋体,凡是英文都是Arial,该怎么写?
- 求助:三联动失效,DATAGRID样式丢失,LINKB点击无反映
- 关于动态表格定位问题
- 急!新手散80分向各位高手求教一个关于查询结果分页的问题!在线等待中~~~
- 请问这两种方法怎么传第一个参数???
- Nhibernate 问题求助,在线等,急,分数全部送上。
- .net开发的OA,在装有上网助手的机器上不能运行?
- 为什么我的vb.net没有 Page.RegisterStartupScript属性,而c#里却有?
- 求教大家一个问题sqlhelper类型无法转换
- 为什么编辑detailview后更新时得不到模板里textbox的值
from tb
group by name
from gzb
group by [name]
from tbname
group by id
select [id], [name],sum(gongzi) as NewGongzi from yourtablename group by [name]
insert @t select 1,'张三',1000
union all select 2,'李四',2000
union all select 3,'张三',2000
union all select 4,'李四',3000
union all select 5,'王五',3000select * from @t select [name],isnull(sum(gongzi),0) as gongzi
from @t
group by [name]
order by [name]
/*
所影响的行数为 5 行)id name gongzi
----------- ---------- --------------
1 张三 1000.00
2 李四 2000.00
3 张三 2000.00
4 李四 3000.00
5 王五 3000.00(所影响的行数为 5 行)name gongzi
---------- ----------------------------------------
李四 5000.00
王五 3000.00
张三 3000.00(所影响的行数为 3 行)*/
go
use lianxi
go
create table gongzi
(
id int,
[name] varchar(20),
gongzi int
)
go
insert into gongzi values(1,'张三',1000)
insert into gongzi values(2,'李四',2000)
insert into gongzi values(3,'张三',2000)
insert into gongzi values(4,'李四',3000)
insert into gongzi values(5,'王五',3000)
select [name],sum(gongzi) from gongzi group by [name])
go
use lianxi
go
create table gongzi
(
id int,
[name] varchar(20),
gongzi int
)
go
insert into gongzi values(1,'张三',1000)
insert into gongzi values(2,'李四',2000)
insert into gongzi values(3,'张三',2000)
insert into gongzi values(4,'李四',3000)
insert into gongzi values(5,'王五',3000)
select [name],sum(gongzi) from gongzi group by [name])
SELECT name AS '姓名',SUM(gongzi) AS '工资' FROM dbo.Pay
GROUP BY name
from 表
group by name
from gzb
group by [name]
from gzb
group by [name]
from 表
group by name
from tb
group by name
select name,gongzi
from 表
group by name