- UID
- 370916
- 主题
- 注册时间
- 2013-6-2
- 在线时间
- 小时
- 最后登录
- 1970-1-1
签到天数: 46 天 [LV.5]常住居民I
|
发表于 2014-2-23 23:36:09
|
显示全部楼层
sqlite> select A.stu_id,A.sub_id,B.max from tbl_score A inner join (select sub_id,max(sub_score) as max from tbl_score group by sub_id) B on A.sub_id=B.sub_id and A.sub_score=B.max; |
|