我想在 SQL Server 中尋求一點幫助。
我需要把客戶買的東西加起來。
我的子查詢只對整個表的總數求和，但我需要類似的東西
Numero D TotalItem TotalBOUGHT
-----------------------------------------------
111 800 1200
111 200 1200
111 100 1200
111 100 1200
455 200 300
455 100 300
這是我的代碼
SELECT
NumeroD, Descrip AS ClientName, CodClie AS ID,
Descrip1 AS Description, TotalItem, CodUbic,
Día_Transaccion AS Day, Mes AS Month, ANO AS YEAR,
(SELECT SUM(TotalItem) FROM FORMULAFINAL) AS TotalAmount
FROM
FORMULAFINAL
WHERE
Descrip LIKE 'Hector%'
GROUP BY
TotalItem, NumeroD, Descrip, CodClie, Descrip1,
TotalItem, CodUbic, Día_Transaccion, Mes, Ano
ORDER BY
Ano DESC, NumeroD, Descrip, Descrip1, CodClie, TotalItem,
CodUbic, Día_Transaccion, Mes
在此處輸入影像描述
uj5u.com熱心網友回復：
也許使用像下面這樣的視窗函式
select
NumeroD, Descrip AS ClientName, CodClie AS ID, Descrip1 AS Description, TotalItem, CodUbic, Día_Transaccion AS Day, Mes AS Month, ANO AS YEAR,
SUM(TotalItem) OVER (partition by NumeroD, DAY, MONTH, YEAR ) AS TotalAmount
FROM FORMULAFINAL
WHERE Descrip LIKE 'Hector%'
ORDER BY Ano DESC, NumeroD, Descrip, Descrip1, CodClie, TotalItem, CodUbic, Día_Transaccion, Mes
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/463085.html