(t.id, t.employee_id) IN (
SELECT substring(MAX(CONCAT(DATE_FORMAT(monitoring_start_date,'%Y-%m-%d'),id)),11), employee_id
FROM vk_personnal_dose_item
MySQL分组查询,然后按日期和ID取日期最大时的ID,如果日期一样取大的ID
最新推荐文章于 2024-07-18 02:07:59 发布
(t.id, t.employee_id) IN (
SELECT substring(MAX(CONCAT(DATE_FORMAT(monitoring_start_date,'%Y-%m-%d'),id)),11), employee_id
FROM vk_personnal_dose_item