USE Northwind

SELECT	OrderId,
		UnitPrice,
		Quantity,
		UnitPrice * Quantity AS RowAmt,
		(SELECT SUM(UnitPrice * Quantity)
			FROM [Order Details]
			WHERE OrderId = o.OrderId)  AS 'Running Total'
	FROM [Order Details] o