sql-server-2008 - 将 sql 中的 2 列相乘并使用 SQL 对所有结果求和

Question

我现在写了一个乘以列的查询，我想总结一下我得到的结果，任何人都可以给我一个想法

这就是我写的
select Rate,Qty,(Rate*Qty) as result
from tblName
我会得到结果，例如 40 90现在我想总结这些结果

Answer 1

原答案

select Sum(Rate) as Rate, Sum(Qty) as Qty, Sum(Rate*Qty) as Result from tblName

编辑 - 尝试这个..

select 
     0 as TotalRow, 
     Rate,
     Qty,
    (Rate*Qty) as Result 
from tblName

UNION ALL

select 
     1 as TotalRow,
     Sum(Rate) as Rate, 
     Sum(Qty) as Qty, 
     Sum(Rate*Qty) as Result 
 from tblName

Order By TotalRow