select id,name,sum() as from "TableName" group by id
select name,sum() as from "TableName" group by name
select min(id) AS ID,max(name) AS name ,sum() as from "TableName" group by name
select min(id) AS ID,name ,sum() as from "TableName" group by name
create table test ( id int, [name] varchar(30), int ) go insert into test values(1,'张三',23) insert into test values(2,'李四',23) insert into test values(3,'李四',23) go select min(id), sum(),[name] from test group by [name] go内容 1 张三 23 2 李四 23 3 李四 23查询结果 2 46 李四 1 23 张三
select min(id) AS '编号',max(name) AS '姓名' ,sum() as '分数' from '表名' group by '姓名'
select min(id),name,sum() from tableName group by name
如果是这样的 id name 01 张三 56 02 李四 76 03 李四 67 04 王五 75 那么查出来应该是 id name 01 张三 56 02 李四 143 03 王五 75 还是 id name 01 张三 56 02 李四 143 04 王五 75
select min(id) , name , sum() from student group by name order by id asc
(
id int,
[name] varchar(30),
int
)
go
insert into test values(1,'张三',23)
insert into test values(2,'李四',23)
insert into test values(3,'李四',23)
go
select min(id), sum(),[name] from test group by [name]
go内容
1 张三 23
2 李四 23
3 李四 23查询结果
2 46 李四
1 23 张三
select min(id) AS '编号',max(name) AS '姓名' ,sum() as '分数' from '表名' group by '姓名'
id name
01 张三 56
02 李四 76
03 李四 67
04 王五 75
那么查出来应该是
id name
01 张三 56
02 李四 143
03 王五 75
还是
id name
01 张三 56
02 李四 143
04 王五 75
from student
group by name
order by id asc