mysql分组查询,且查询每组最新的一条数据
基于MySQL版本5.6和5.7
MySQL版本5.6:
SELECT
ta.f_grade_id id,
ta.f_appointment_time maxTime
FROM
(
SELECT
f_appointment_time,
f_grade_id
FROM
lms.t_lms_teacher_appointment
WHERE
f_is_delete = 0
ORDER BY
f_appointment_time DESC
) ta
GROUP BY
ta.f_grade_id ;
MySQL版本5.7:
SELECT
ta.f_grade_id id,
ta.f_appointment_time maxTime
FROM
(
SELECT DISTINCT
f_appointment_time,
f_grade_id
FROM
lms.t_lms_teacher_appointment
WHERE
f_is_delete = 0
ORDER BY
f_appointment_time DESC
) ta
GROUP BY
ta.f_grade_id ;
注意:1、5.7需要加distinct以让sql强制排序。5.6则不需要。
2、查询字段必须要有排序字段(f_appointment_time)