mysql 求通过率 用float表示出来。求大神帮忙，急。。。
- WBOYOriginal
- 2016-06-06 09:43:01927browse
mysql
select ((select COUNT(ut.status) from user_test ut where ut.userid=252 and ut.status=1)/(COUNT(ut.status))) as '考试通过率'
from user_test ut
where ut.userid=252 我求的是通过率，要怎么把select后面查询出的结果用float表示。
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：fetch-mysql_real_query返回值是1,一直删除失败Next article：mysql-有数据库表结构，但是属性太多，如何自动导入建表