SQL server 统计分组经计

SUM(A.AREA) OVER ( PARTITION BY A.ItemNo, A.PARTS ,A.WIDTH,A.HEIGHT) allotQty,
SUM(A.SL) OVER ( PARTITION BY A.ItemNo, A.PARTS,A.WIDTH,A.HEIGHT ) auAllotQty,

posted @ 2019-08-21 08:26  A汉克先生  阅读(470)  评论(0编辑  收藏  举报