select name , avg(salary) from student group by name , grade 查看表中人員的工資平均數(同姓工資平均數) 得出的如下結果 max():最大值 select grade , max(salary) from student group by grade 查看按等級劃分人員工資最大值 得出的如下結果 min():最小值 select grade , min(salary) from student g...
www.dbjr.com.cn/article/2319...htm 2025-6-7