34,576
社区成员
发帖
与我相关
我的任务
分享
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