SELECT A.ORDER_ID,A.OP_DATE,row_number() OVER(PARTITION BY a.order_id ORDER BY A.op_date DESC) RN FROM TV_BU_BILL_RECORD A
转载于:https://www.cnblogs.com/Linger-wj/p/8608237.html
SELECT A.ORDER_ID,A.OP_DATE,row_number() OVER(PARTITION BY a.order_id ORDER BY A.op_date DESC) RN FROM TV_BU_BILL_RECORD A
转载于:https://www.cnblogs.com/Linger-wj/p/8608237.html