MySQL percentage _ MySQL

MySQL percentage bitsCN.com

The report business requires that the percentage of fields in the table be calculated. the SQL statement is as follows (the SQL table is my business table and must be changed ):
Mysql code
SELECT biz_type, round (sumCate/sumCount) * 100,2) as percent
From (select biz_type, count (id) as sumCate from sta_report group by biz_type) as,
(Select count (id) as sumCount from sta_report) as B

You only need to add "%" to the result. The result has been multiplied by "100" and the result has been truncated to contain only two decimal places.
SQL statements that take the last two digits of the decimal point:
Select round (decimal, 2) from table
Select convert (decimal (), round (decimal, 2) from table
Select cast (decimal as numeric (10, 2) from table

Author "angry three meters"

BitsCN.com