SELECT ACCT_NO,ACCT_NAME,SEND_TIME,TRAN_AMT FROM( SELECT E.★.,row_number() over(partition by E.ACCT_NAME order by SEND_TIME DESC) RES FROM E_TRANS E )WHERE RES = 1 ORDER BY SEND_TIME DESC
去重SELECT ACCT_NO,ACCT_NAME,SEND_TIME,TRAN_AMT FROM(SELECT E.★.,row_number() over(partition by E.ACCT_NAME order by SEND_TIME DESC) RES FROM E_TRANS E )WHERE RES = 1 ORDER BY SEND_TIME DESC