请高手帮忙, 第3题的 2,3,4小题, 急用.....
------解决方案--------------------
给分吧,哈哈
------解决方案--------------------
- SQL code
select 姓名,total_avg from (select 学号,姓名,avg(成绩) total_avg from ljy group by 学号,姓名 order by total_avg desc)where rownum=1
select 姓名,total_avg from (select 学号,姓名,avg(成绩) total_avg from ljy group by 学号,姓名 order by total_avg desc)where rownum=1