34,593
社区成员
发帖
与我相关
我的任务
分享
select *,sum(A6) over(partition by A2,A7,A9 ) into T2 from T1
select * from T2
CREATE TABLE Ctemp1
(
A1 varchar(10),
A2 varchar(10),
A3 varchar(10),
A4 varchar(10),
A5 varchar(10),
A6 int,
A7 varchar(10),
A8 varchar(10),
A9 varchar(10),
)
INSERT INTO Ctemp(A1,A2,A3,A4,A5,A6,A7,A8,A9)VALUES('a1','b1','c1','d1','e1',5,'f1','g1','h1')
INSERT INTO Ctemp(A1,A2,A3,A4,A5,A6,A7,A8,A9)VALUES('a2','b2','c2','d2','e2',10,'f2','g2','h2')
INSERT INTO Ctemp(A1,A2,A3,A4,A5,A6,A7,A8,A9)VALUES('a3','b3','c3','d3','e3',15,'f3','g3','h3')
INSERT INTO Ctemp(A1,A2,A3,A4,A5,A6,A7,A8,A9)VALUES('a4','b4','c4','d4','e4',55,'f4','g4','h4')
INSERT INTO Ctemp(A1,A2,A3,A4,A5,A6,A7,A8,A9)VALUES('a5','b5','c5','d5','e5',51,'f5','g5','h5')
SELECT a1,a2,(sum(a6)) AS a10 FROM Ctemp GROUP BY a1,a2
select A2,A7,A9,sum(A6) into T2 group by A2,A7,A9
select A2,A7,A9,sum(A6) as A6
into T2 group by A2,A7,A9
ct A2,A7,A9,sum(A6) into T2 group by A2,A7,A9
或其它字段都用max()
select A2,A7,A9,sum(A6) into T2 group by A2,A7,A9
--只要使用聚合函数,,其它字段也必须放在group by中,,或者使用 max(),min()包含其它字段,,
select A2,A7,A9,sum(A6) into T2 group by A2,A7,A9