select t3.name,max(t3.gradeid),t3.grade from test3 t3, (select name, max(grade) grade from test3 group by name) t where t3.name = t.name and t3.grade = t.grade group by t3.name,t3.grade
SELECT a.name,Max(a.gradeid),a.grade,a.num FROM (SELECT name,gradeid,grade,ROWNUM AS num FROM test3) a GROUP by name,grade,a.num
from test3 t3, (select name, max(grade) grade from test3 group by name) t
where t3.name = t.name
and t3.grade = t.grade
group by t3.name,t3.grade
GROUP by name,grade,a.num
fjmingyang(努力升级) 是对的 !
fjmingyang(努力升级) 是对的 !
fjmingyang(努力升级) 是对的 !