sqlserversum汇总偷懒不用groupby

简书链接:sqlserversum汇总偷懒不用groupby
文章字数：107,阅读全文大约需要1分钟
因为select的字段比较多，但是实际上只要分组 标题 1 标题2。
select column1,column2,column3,column4,column5,,SUM(qty) as total_qty ** group by column1,column1,column3,column4
改为
select column1,column2,column3,column4,SUM(qty) OVER (PARTITION BY column1, column2) as total_qty

方法2
用with CTE 表达式

wITH TotalQty AS (
    SELECT 
        id, 
        SUM(qty) as total_qty
    FROM 
        table
    GROUP BY 
        id
)
SELECT 
    t1.column1,
    t1.column2,
    t2.total_qty
FROM 
    table1 t1
INNER JOIN 
    TotalQty t2
ON 
    t1.id = t2.id;

方法3 子查询或CROSS APPLY 子查询，CROSS APPLY用法看我上一篇文章