...
Code Block | ||
---|---|---|
| ||
SELECT a,
COUNT(b) OVER (PARTITION BY c) AS b_count,
SUM(b) OVER (PARTITION BY c) AS b_sum
FROM T; |
WINDOW clause
...
...
Code Block | ||
---|---|---|
| ||
SELECT a,
COUNT(b) OVER (PARTITION BY c) AS b_count,
SUM(b) OVER (PARTITION BY c) AS b_sum
FROM T; |
...