【原理】三级教程P118
【代码】
SELECT A#,B#,QTY,
SUM(QTY) OVER(PARTITION BY A#) AS 'TOTAL',
MAX(QTY) OVER(PARTITION BY A#) AS 'MAX'
FROM AB
【截图】
【原理】三级教程P118
【代码】
SELECT A#,B#,QTY,
SUM(QTY) OVER(PARTITION BY A#) AS 'TOTAL',
MAX(QTY) OVER(PARTITION BY A#) AS 'MAX'
FROM AB
【截图】