/*------------------------------------------------------------------ -- Author : htl258(Tony) -- Date : 2010-04-12 16:47:38 -- Version: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)------------------------------------------------------------------*/ --> 生成测试数据表:aIF OBJECT_ID('[a]') IS NOT NULL DROP TABLE [a] GO CREATE TABLE [a]([序号] NVARCHAR(10),[数值] INT) INSERT [a] SELECT 'A',1 UNION ALL SELECT 'B',2 UNION ALL SELECT 'C',3 UNION ALL SELECT 'C',4 UNION ALL SELECT 'B',5 UNION ALL SELECT 'B',6 UNION ALL SELECT 'A',7 GO --SELECT * FROM [a]-->SQL查询如下: select 序号,sum( 数值) 数值 from a group by 序号 /* 序号 数值 ---------- ----------- A 8 B 13 C 7(3 行受影响) */
select 序号 , sum(数值) 数值 from tb group by 序号
CREATE TABLE [tb]([序号] NVARCHAR(10),[数值] INT) INSERT [tb] SELECT 'A',1 UNION ALL SELECT 'B',2 UNION ALL SELECT 'C',3 UNION ALL SELECT 'C',4 UNION ALL SELECT 'B',5 UNION ALL SELECT 'B',6 UNION ALL SELECT 'A',7select 序号 , sum(数值) 数值 from tb group by 序号drop table tb/* 序号 数值 ---------- ----------- A 8 B 13 C 7(所影响的行数为 3 行) */
/*------------------------------------------------------------------
-- Author : htl258(Tony)
-- Date : 2010-04-12 16:47:38
-- Version: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
Jul 9 2008 14:43:34
Copyright (c) 1988-2008 Microsoft Corporation
Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)------------------------------------------------------------------*/
--> 生成测试数据表:aIF OBJECT_ID('[a]') IS NOT NULL
DROP TABLE [a]
GO
CREATE TABLE [a]([序号] NVARCHAR(10),[数值] INT)
INSERT [a]
SELECT 'A',1 UNION ALL
SELECT 'B',2 UNION ALL
SELECT 'C',3 UNION ALL
SELECT 'C',4 UNION ALL
SELECT 'B',5 UNION ALL
SELECT 'B',6 UNION ALL
SELECT 'A',7
GO
--SELECT * FROM [a]-->SQL查询如下:
select 序号,sum( 数值) 数值 from a group by 序号
/*
序号 数值
---------- -----------
A 8
B 13
C 7(3 行受影响)
*/
INSERT [tb]
SELECT 'A',1 UNION ALL
SELECT 'B',2 UNION ALL
SELECT 'C',3 UNION ALL
SELECT 'C',4 UNION ALL
SELECT 'B',5 UNION ALL
SELECT 'B',6 UNION ALL
SELECT 'A',7select 序号 , sum(数值) 数值 from tb group by 序号drop table tb/*
序号 数值
---------- -----------
A 8
B 13
C 7(所影响的行数为 3 行)
*/