https://blog.csdn.net/persistencegoing/article/details/92764058
All rights reserved.No part of this article may be reproduced or distributed by any means,or stored in a database or retrieval system,without the prior written permission of persistenceGoing author
https://blog.csdn.net/persistencegoing/article/details/84376427
有一个学生分数表student,数据结构是这样的
id(当前表ID) student_id(学生ID) line(分数) subject_type(科目类型)
1 1 80 1
2 1 78 1
3 1 56 1
4 2 99 1
5 2 20 1
我想根据学生分组 ,得到每个分组中分数最高的那一条数据:
|