这里是sqlserver专区,所以只能给你sqlserver的写法,至于mysql行不行,我就不知道了,不行的话你去mysql问吧---------------------------------------------------------------- -- Author :DBA_Huangzj(發糞塗牆) -- Date :2014-02-11 13:39:18 -- Version: -- Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) -- Dec 28 2012 20:23:12 -- Copyright (c) Microsoft Corporation -- Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) -- ---------------------------------------------------------------- --> 测试数据:[huang] if object_id('[huang]') is not null drop table [huang] go create table [huang]([ID] int,[name] varchar(5),[pass] varchar(2),[num] int) insert [huang] select 1,'mysql','qq',45 union all select 2,'js','ww',33 union all select 1,'mysql','qq',23 union all select 2,'js','ww',5 --------------开始查询--------------------------select id,name,pass,SUM(num)num from [huang] GROUP BY id,name,pass ----------------结果---------------------------- /* id name pass num ----------- ----- ---- ----------- 1 mysql qq 68 2 js ww 38 */
mysql应该能执行,这里没有什么特殊写法---------------------------------------------------------------- -- Author :DBA_Huangzj(發糞塗牆) -- Date :2014-02-11 13:39:18 -- Version: -- Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) -- Dec 28 2012 20:23:12 -- Copyright (c) Microsoft Corporation -- Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) -- ---------------------------------------------------------------- --> 测试数据:[huang] if object_id('[huang]') is not null drop table [huang] go create table [huang]([ID] int,[name] varchar(5),[pass] varchar(2),[num] int) insert [huang] select 1,'mysql','qq',45 union all select 2,'js','ww',33 union all select 1,'mysql','qq',23 union all select 2,'js','ww',5 --------------开始查询--------------------------select id,name,pass,SUM(num)num from [huang] GROUP BY id,name,pass ----------------结果---------------------------- /* id name pass num ----------- ----- ---- ----------- 1 mysql qq 68 2 js ww 38 */
这个可以吧? select ID,name,pass, sum(num)AS sum from test group by name
-- Author :DBA_Huangzj(發糞塗牆)
-- Date :2014-02-11 13:39:18
-- Version:
-- Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
-- Dec 28 2012 20:23:12
-- Copyright (c) Microsoft Corporation
-- Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )
--
----------------------------------------------------------------
--> 测试数据:[huang]
if object_id('[huang]') is not null drop table [huang]
go
create table [huang]([ID] int,[name] varchar(5),[pass] varchar(2),[num] int)
insert [huang]
select 1,'mysql','qq',45 union all
select 2,'js','ww',33 union all
select 1,'mysql','qq',23 union all
select 2,'js','ww',5
--------------开始查询--------------------------select id,name,pass,SUM(num)num
from [huang]
GROUP BY id,name,pass
----------------结果----------------------------
/*
id name pass num
----------- ----- ---- -----------
1 mysql qq 68
2 js ww 38
*/
-- Author :DBA_Huangzj(發糞塗牆)
-- Date :2014-02-11 13:39:18
-- Version:
-- Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
-- Dec 28 2012 20:23:12
-- Copyright (c) Microsoft Corporation
-- Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )
--
----------------------------------------------------------------
--> 测试数据:[huang]
if object_id('[huang]') is not null drop table [huang]
go
create table [huang]([ID] int,[name] varchar(5),[pass] varchar(2),[num] int)
insert [huang]
select 1,'mysql','qq',45 union all
select 2,'js','ww',33 union all
select 1,'mysql','qq',23 union all
select 2,'js','ww',5
--------------开始查询--------------------------select id,name,pass,SUM(num)num
from [huang]
GROUP BY id,name,pass
----------------结果----------------------------
/*
id name pass num
----------- ----- ---- -----------
1 mysql qq 68
2 js ww 38
*/
这个可以吧?
select ID,name,pass, sum(num)AS sum from test group by name