5,891
社区成员




SELECT
RS.CO_NUM, RS.PAY_DATE, RS.LOG_ID
FROM
( SELECT T.CO_NUM, T.PAY_DATE, T.LOG_ID,
ROW_NUMBER() OVER(PARTITION BY T.CO_NUM ORDER BY T.PAY_DATE DESC, T.LOG_ID DESC) ROW_ID
FROM EC_PAY_LOG_TEST1 T ) RS
WHERE
RS.ROW_ID = 1