mysql获取百分⽐函数,并对结果保留2位⼩数。具体使⽤:
CONCAT( ROUND( vcr.number_vote / ct.number_vote * 100, 2 ), '', '%' )预防性侵害
例:求某表中的⼀列所占的百分⽐
SELECT
CONCAT(
ROUND(
工程资料员vcr.number_vote / ct.number_vote * 100,
2
),
'',
'%'
个人资信证明)
,
十二寸蛋糕多大vcr.*
FROM
干部考核谈话vote_candidacy_re vcr
LEFT JOIN
眼霜怎么用(SELECT
SUM(number_vote) AS number_vote
FROM
vote_candidacy_re
筹资费用WHERE vote_id = 2) ct
ON 1 = 1瓠子的做法
WHERE vcr.vote_id = 2
ORDER BY vcr.number_vote DESC