select name,round(avg(score),2)as average_score
from(select c.name name,r.score score from rankings r innerjoin categories c on r.category_id=c.id)as a
groupby name
今天刷sql题目的时候,遇到了这个问题,特地记下来。使用round()函数,接受两个参数,一个是需要保留小数的数据,一个是指定保留多少位例如round(2,3)输出的即是2.000,保留三位有效数字实例select name,round(avg(score),2) as average_scorefrom (select c.name name,r.score score from rankings r inner join categories c on r.category_id=c.id) a