mysql一对多取最新的一条

等等邓灯

于 2022-10-17 11:42:09 发布

阅读量575

点赞数

CC 4.0 BY-SA版权

分类专栏：软件文章标签： mysql 数据库

本文链接：https://blog.csdn.net/qq_39908911/article/details/127360652

软件专栏收录该内容

3 篇文章

订阅专栏

本文分析了2022年8月期间ECL学生针对'投诉处理'和'课程质量'的工单数据，重点关注了TC-XA至TC-BJ的教学中心，揭示了学生账户过期时间，并讨论了教学改进措施。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT
table1.*,
table2.expiration_time expirationTime
FROM
(
SELECT
stu.id student,
wo.id woId,
wo.created,
wo.summary,
wo.last_follow_up,
nl.teacher_id
FROM
wo_work_order wo
LEFT JOIN student stu ON wo.student_id = stu.id
LEFT JOIN new_lesson nl ON nl.id = wo.lesson_id
WHERE
wo.category IN ( ‘complaint_processing’, ‘lesson_quality_complaint’ )
AND wo.created > ‘2022-08-16 00:00:00’
AND wo.created < ‘2022-8-22 00:00:00’
AND stu.classification = ‘ECL’
AND stu.role <> ‘VIRTUAL’
AND stu.teaching_center IN ( ‘TC-XA’, ‘TC-WH’, ‘TC-CS’, ‘TC-BJ’, ‘NOT-SETTING’ )) table1
LEFT JOIN ( SELECT student_id, MAX( expiration_time ) expiration_time FROM sim_account GROUP BY student_id ) table2 ON table1.student = table2.student_id