SELECT
*
FROM
(
SELECT
*,
ROW_NUMBER () OVER (PARTITION BY patientid ORDER BY diag_time desc) AS ROW
FROM
health_patient_tags
WHERE
tagid = 1003
) T
WHERE
ROW = 1
给患者分组,并给组内数据排序。row为排好的序号
SELECT
*
FROM
(
SELECT
*,
ROW_NUMBER () OVER (PARTITION BY patientid ORDER BY diag_time desc) AS ROW
FROM
health_patient_tags
WHERE
tagid = 1003
) T
WHERE
ROW = 1
给患者分组,并给组内数据排序。row为排好的序号