查询按每天最新时间的一条数据
SELECT
MAX( diagndate ) medate
FROM
xxx_xxx
WHERE
TO_DAYS( diagndate ) = TO_DAYS( '2020-06-12 16:03:16' ) -- 前端传入的当前诊断时间
AND xxx = '24552'
SELECT
MAX( diagndate ) medate
FROM
xxx_xxx
WHERE
TO_DAYS( diagndate ) = TO_DAYS( '2020-06-12 16:03:16' ) -- 前端传入的当前诊断时间
AND xxx = '24552'