group by方法显示多个字段怎么显示

group by方法显示多个字段怎么显示

select t2.* from
(select objectName,max(fenshu) as maxfenshu from studentInfo group by objectName) t, studentInfo t2
where t.objectName=t2.objectname and t.maxfenshu=t2.fenshu;