表结构 (姓名,课程,成绩) 现在求获的该表总成绩最高学员的名字
9条回答 默认 最新
- 丵鹰 2015-08-27 14:54关注
mysql 数据库select sum(成绩) as t from table group by 姓名 order by t limit 0,1
oracle数据库 select * from (select sum(成绩) as t from table group by 姓名 order by t) WHERE ROWNUM<=1
sqlserver数据库 select top 1 sum(成绩) as t from table group by 姓名 order by t本回答被题主选为最佳回答 , 对您是否有帮助呢?解决评论 打赏 举报无用 1