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