Oracle分组获取最新记录示例

获取最新检验结果

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