How to calculate the percentage by MySQL

This article mainly introduces how to calculate the percentage of MySQL. It is very detailed and has a certain reference value. Friends who are interested must read it!

Report business requirements require the percentage of field classification in the table. SQL is as follows (the table in SQL is my business table, which must be changed):

Mysql code

SELECT biz_type,round ((sumCate/sumCount) * 100Pol 2) as percent

From (select biz_type, count (id) as sumCate from sta_report group by biz_type) as a

(select count (id) as sumCount from sta_report) as b

The result only needs to add "%", it has been multiplied by "100", and the result has been truncated to contain only two decimal places.

Attach two statements after the decimal point in SQL:

Select round (decimal, 2) from table

Select convert (decimal (18jue 2), round (decimal, 2)) from table

Select cast (decimal as numeric (10) 2) from table

The above is all the contents of the article "how to get the percentage of MySQL". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!