<!--获取指定课堂客观题统计列表-->
<select id="listObjective" resultType="XXX.vo.classinteraction.CCAskTeacherBean">
SELECT t.asktid,t.teacherpic,t.radioanswer,CONCAT(ROUND(COUNT(*)/c.groupnum*100,2),'%')correctRate FROM cc_ask_student s
RIGHT JOIN cc_ask_teacher t ON s.asktid=t.asktid LEFT JOIN cc_class c ON t.classid=c.classid
WHERE t.classid=#{classid} AND t.asktype IN(30,31) AND t.radioanswer=s.studentradio GROUP BY t.asktid ORDER BY t.asktid
</select>
mybatis统计试题正确率(保留小数点后两位四舍五入后的值)
最新推荐文章于 2022-10-31 16:56:58 发布