简介
使用 round 与 avg
select job, round(avg(score),3) as avg
from grade
group by job
order by avg desc;
考试分数(一)
Hope is a good thing,maybe the best of things,and no good thing ever dies.----------- Andy Dufresne
使用 round 与 avg
select job, round(avg(score),3) as avg
from grade
group by job
order by avg desc;