Oracle分组获取最新记录示例
2024-06-13 本文已影响0人
Q轩哥
获取最新检验结果
SELECT * FROM (
SELECT t.*,ROW_NUMBER() OVER (partition by item_id ORDER BY REPORT_DATE DESC) AS rn
FROM ( select b.*,a.REPORT_DATE from(
select * from v_kyy_mz_lis where PATIENT_ID='2910212'
) a
join V_KYY_MZ_LIS_DETAIL b on a.report_id = b.report_id
)t
) list
WHERE rn = 1
