如何用MYSQL进行百分比查询
首先查询出每个的数量
select work_efficiency,COUNT(*) as total from ylxm_maintain where work_efficiency!='' group by work_efficiency
接着查询总数
select count(*) as total from ylxm_maintain where work_efficiency!=''
最后进行百分比查询
select work_efficiency,COUNT(*) as total,
cast( convert (decimal(18,2),100*cast(count(*) as float)/cast((select count(*) from ylxm_maintain where work_efficiency!='') as float) ) as varchar)+'%' as cent
from ylxm_maintain where work_efficiency!='' group by work_efficiency
order by cent desc
这样就可以ok了。