Shulou(Shulou.com)06/01 Report--

Extract the corresponding count number according to the corresponding condition (myCount)

Total count extracted (totalCount)

Calculate percentage: myCount / totalCount * 100

Rounding: Use the ROUND function ROUND(number, decimal places to keep), ROUND(myCount / totalCount * 100,1)

Examples are given below for reference:

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;

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.