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;





暑期編程PK賽


得CSDN機械鍵盤等精美禮品！