mysql连接查询-主从表连接查询：获取从表最新一条表记录；获取没有从表记录的主表信息

最新推荐文章于 2024-07-24 22:48:16 发布

温妮露露

最新推荐文章于 2024-07-24 22:48:16 发布

阅读量1.6k

点赞数 1

CC 4.0 BY-SA版权

文章标签： mysql select

本文链接：https://blog.youkuaiyun.com/lu_zhang2008/article/details/11085895

A表学生表Student

id,name,sex,age

B表成绩表 score

id,student_id,score,create_tm

获取每个学生最新的考试成绩

select stu.id,stu.name,score.score from student stu left out join (select * from（select student_id,score from score order by create_tm desc）s group by student_id) score on stu.id=socre.student_id

获取没有考试成绩的学生

select stu.id,stu.name,score.score from student stu left out join (select * from（select student_id,score from score order by create_tm desc）s group by student_id) score on stu.id=socre.student_id where score.score is null