php - SQL百分比查询

Question

我有以下查询:

SELECT SUM(KDV_Haric_Ciro) AS Ciro
     , Ana_Kategori
  FROM general_Table
 Where EczaneID = $pharmacy_id
   AND Yil = '$dateYear'
 GROUP 
    BY Ana_Kategori
 ORDER 
    BY Ciro DESC

但我想要以百分比表示的结果。

目前结果是这样的:

A 5
B 7
C 8

我尝试过使用百分比方法进行嵌套查询，但都失败了。

Answer 1

要获得百分比，您需要总计。为此，您需要进行另一次计算。一种方法是:

SELECT gt.Ana_Kategori, SUM(gt.KDV_Haric_Ciro) AS Ciro,
       SUM(gt.KDV_Haric_Ciro) / total.KDV_Haric_Ciro as ratio
FROM general_Table gt CROSS JOIN
     (SELECT SUM(gt2.KDV_Haric_Ciro) as KDV_Haric_Ciro
      FROM general_Table gt2
      WHERE gt2.EczaneID = '".$pharmacy_id."' AND gt2.Yil = '".$dateYear."'
     ) total
WHERE gt.EczaneID = '".$pharmacy_id."' AND gt.Yil = '".$dateYear."'
GROUP BY gt.Ana_Kategori
ORDER BY `Ciro` DESC;

注意:您不应该使用参数值修改查询字符串。您应该学习如何编写参数化查询。