如何划分行结果 [英] how Can Divide row result

问题描述

（ select  sum（Amount）
  from  Receipt_NoteDetalisTBL 
  group   by  Product_Id 
  HAVING  Product_Id =  1  
）
 \ 
（
 选择总和（数量）
 来自 Receipt_NoteDetalisTBL 
  group   by  Product_Id 
  HAVING  Product_Id =  1  
）

对于例子来说

结果1 = 100

结果2 = 200





结果1/2 = 0.5

解决方案

声明变量：

示例：

 < span class =code-keyword> SELECT  SUM（金额）/ SUM（数量） AS 结果
  FROM  Receipt_NoteDetalisTBL 
  GROUP   BY  Product_Id 
  HAVING  Product_Id =  1  

希望有所帮助：）

用于显示的总和（金额）和总和（数量）你可以在 SELECT 子句中编写它。类似于：

  SELECT  sum（金额）/ sum（数量） AS 结果
  FROM  Receipt_NoteDetalisTBL 
  GROUP   BY  Product_Id 
  HAVING  Product_Id =  1  

(select sum(Amount)
from  Receipt_NoteDetalisTBL
group by Product_Id
HAVING Product_Id = 1
)
\
(
select sum(Quantity)
from  Receipt_NoteDetalisTBL
group by Product_Id
HAVING Product_Id = 1
)

For Excample
result 1 = 100
result 2 = 200


result 1 / 2 =0.5

解决方案

Declare the variable:
EXAMPLE:

SELECT SUM(Amount) / SUM(Quantity) AS Result
FROM  Receipt_NoteDetalisTBL
GROUP BY Product_Id
HAVING Product_Id = 1

Hope it helps :)

For showing the division of sum(Amount) and sum(Quantity) you can just write it in the SELECT clause. Something like:

SELECT sum(Amount) / sum(Quantity) AS Result
FROM  Receipt_NoteDetalisTBL
GROUP BY Product_Id
HAVING Product_Id = 1

这篇关于如何划分行结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！