SQL Server中不重复相同值的所有组合的总和

WITH CTE AS (
  SELECT value, CAST(value AS VARCHAR(MAX)) AS combination
  FROM table
  UNION ALL
  SELECT t.value, CAST(cte.combination + ',' + CAST(t.value AS VARCHAR(MAX)) AS VARCHAR(MAX))
  FROM table t
  INNER JOIN CTE ON t.value > cte.value
)
SELECT combination
FROM CTE

WITH CTE AS (
  SELECT value, CAST(value AS VARCHAR(MAX)) AS combination
  FROM table
  UNION ALL
  SELECT t.value, CAST(cte.combination + ',' + CAST(t.value AS VARCHAR(MAX)) AS VARCHAR(MAX))
  FROM table t
  INNER JOIN CTE ON t.value > cte.value
)
SELECT SUM(combination_sum) AS total_sum
FROM (
  SELECT combination, ROW_NUMBER() OVER (PARTITION BY combination ORDER BY combination) AS rn, SUM(value) OVER (PARTITION BY combination) AS combination_sum
  FROM CTE
) AS subquery
WHERE rn = 1