SQL每日一题(20210425)
SQL每日一题(20210810)
SQL每日一题(20211027)
SQL每日一题(20211208)
SQL每日一题(2021227)
SQL每日一题(20220207)
SQL每日一题(20220509)
SELECT Z.HU, Z.SERIAL_NUMBER, X.CHARG,Z.RM,X.SM , X.QTY
FROM (SELECT A.*, SUM(A.QTY) OVER (ORDER BY A.CHARG) SM FROM T0122A A) X
JOIN (SELECT Y.*, ROWNUM RM FROM (SELECT B.* FROM T0122B B ORDER BY DBMS_RANDOM.VALUE) Y) Z
ON X.HU = Z.HU AND (Z.RM >X.SM - X.QTY AND Z.RM <= X.SM)