1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
/* syntax version 1 */
/* postgres can not */
PRAGMA DistinctOverWindow;
$input = AsList(
AsStruct(1 AS key, 1001 AS subkey, "AAA" AS value),
AsStruct(150 AS key, 150 AS subkey, "AAB" AS value),
AsStruct(3 AS key, 3003 AS subkey, "AAC" AS value),
AsStruct(150 AS key, 150 AS subkey, "AAD" AS value),
AsStruct(5 AS key, 5005 AS subkey, "AAE" AS value),
);
SELECT
i.*,
count(DISTINCT key) OVER () AS cnt,
AggregateList(DISTINCT key) OVER () AS agg_list,
FROM AS_TABLE($input) AS i;
|
