Discuss / SQL / 分数保留两位小数

分数保留两位小数

Topic source

select class_id,round(avg(score),2) average from students group by class_id;

select class_id,gender,round(avg(score),2) average from students group by class_id,gender;


  • 1

Reply