select OrderID, UnitPrice, Quantity, (UnitPrice*Quantity) as Total1,
(select sum(UnitPrice*Quantity) from [Order Details] where OrderID=10248) as Total2
from [Order Details]
where OrderID=10248
select OrderID, UnitPrice, Quantity, (UnitPrice*Quantity) as Total1,
(select sum(UnitPrice*Quantity) from [Order Details] where OrderID=10248) as Total2
from [Order Details]
where OrderID=10248
21 palabras