select * from (
SELECT
A .*, ROW_NUMBER () OVER (
PARTITION BY A .llid
ORDER BY
A .yjsj DESC
) rn
FROM
T_SJZL_YJLOGS A WHERE A.yjsj >= to_date(to_char(sysdate,‘yyyy-mm-dd’),‘yyyy-mm-dd’)
) T LEFT JOIN T_SJZL_SJZLDT_LLGX T1 ON T.LLID=T1.DZID where rn =1
获取当前多条数据的最后一条数据
最新推荐文章于 2024-05-14 17:15:27 发布