sql2008 下的储存过程行合并问题

[yushen945]

各位大虾，之前由于是第一次发帖，里面的sql语句复制错了，正确的如下，希望各位再次帮忙下，谢啦
表Test
字段
ID主键 int
WZMC nvarchar(50)
ShuLiang int

例如 NO WZMC ShuLiang
1 鼠标 500
2 鼠标 200

合并后 NO WZMC ShuLiang
1 鼠标 700

自己写的查询语句如下：

SELECT ROW_NUMBER() OVER (ORDER BY ShuLiang DESC) AS NO,WZMC,ShuLiang FROM dbo.Test WHERE 1=1

[孤独加百列]

IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE name = 'tba')
BEGIN
	DROP TABLE tba
END
GO
CREATE TABLE tba
(	NO INT,
	WZMC VARCHAR(10),
	ShuLiang INT
)

GO

INSERT INTO tba
SELECT  1, '鼠标', 500 UNION
SELECT  2, '鼠标', 200


SELECT NO=ROW_NUMBER() OVER (ORDER BY A.shuliang), A.* FROM (SELECT WZMC,SUM(ShuLiang) AS shuliang
FROM tba
GROUP BY WZMC) AS A

[yushen945]

谢谢啦~！