我的枢轴查询正在生成重复的行。有人能解决这个问题吗?DECLARE @SQL AS VARCHAR(MAX)DECLARE @ColumnsRollup AS VARCHAR (MAXFROM SELECT distinct ProjectId ) AS B
SET @SQLFOR ProjectId IN (' + @Column
是否有一种方法只对某些GROUP BY列而不是对所有GROUP BY列进行卷起聚合?而不是SELECT a,b,SUM(c) FROM sample.data GROUP BY a,b或SELECT a,b,SUM(c) FROM sample.data GROUP BY ROLLUP(a,b),我正在尝试实现SELECT a,b,SUM(c) FROM sample.data GROUP BY a, ROLLUP(b)。我现在可以想
我的SQL查询和输出如下: Select from left outeron c.tin = ci.tin lk_zone lk on lk.id = c.id c.delete_dt is not null rollup(caseName, caseBy, lk.descr); 这不会返回如上所述的<