数据去重
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
版权声明：本文为mr_arvin原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。