SQL每日一题(20211029)如果总数量超过A的总数量，则多余的数量，叠加到最后一笔，不足则按剩余数显示。

SQL每日一题(20220402)

Select *,Sum(QTY) Over (Partition By PCode Order By Itemno) a ,
       If(500 >
          Sum(QTY) Over (Partition By PCode Order By Itemno), Qty,
          IF(Sum(QTY) Over (Partition By PCode Order By Itemno) - QTY < 500,
             500 - Sum(QTY) Over (Partition By PCode Order By Itemno) + QTY, 0))
From T1029
Where PCode = 'A001'