a
b
c
SELECT
SalesOrderDetailID,
SalesOrderID,
SUM(LineTotal) OVER (PARTITION BY SalesOrderID)
AS [Total]
FROM Sales.SalesOrderDetail
