MySQL計算百分比方法介紹

根據相應條件抽出相應count數（myCount）

抽出總count數(totalCount)

計算百分比：myCount / totalCount * 100

四舍五入：使用ROUND函數ROUND(number，要保留的小數位)，ROUND(myCount / totalCount * 100,1)

下面給出示例供參考：

    SELECT ROUND(T1.co/T2.totalCo*100,1)

    FROM 

     (SELECT COUNT(*) AS co

        FROM fup1

       WHERE fup1.PERIOD6 = 1

       AND fup1.P6CCTCHK = 2) T1,

     (SELECT COUNT(*) AS totalCo

       FROM fup1

       WHERE fup1.PERIOD6 = 1)T2;

本文轉自  ChinaUnicom110  51CTO部落格，原文連結:http://blog.51cto.com/xingyue2011/1966811