如何选择每个id的最大记录(学期)

Question

如何选择每个学生最喜欢的学期链接图片。

http://i.stack.imgur.com/Ka97X.jpg

Answer 1

select s1.* from  student s1
inner join 
(
    select student_id,max(semester) as semester
    from  student group by student_id
) as  s2 
on s1.student_id=s2.student_id and s1.semester=s2.semester

Answer 2

SELECT *  
FROM STUDENT_SCORE  
GROUP BY student_id  
HAVING MAX(score)

注意:如果需要将id重命名为< code>stnd_tbl_nd，可以在投影之前或之后使用< code>AS关键字进行重命名。