sql查询百分比
Java代码 select v.OBID,CONCAT(`item_count`/(select sum(item_count) from vote_item)*100,'%') as '百分比',s.text from `vote_item` v,`vote_subject` s where s.OBID = v.fk_subject
Java代码 select v.OBID,CONCAT(`item_count`/(select sum(item_count) from vote_item)*100,'%') as '百分比',s.text from `vote_item` v,`vote_subject` s where s.OBID = v.fk_subject
| 评论 |
|
|