日期:2014-05-17 浏览次数:20728 次
select 姓名,total_avg from ( select 学号,姓名,avg(成绩) total_avg from ljy group by 学号,姓名 order by total_avg desc)where rownum=1