blob: b2f1f3583ca51d6a3afc453970c85d117a1093cf (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
|
PRAGMA warning("disable", "4520");
PRAGMA DisableAnsiRankForNullableKeys;
SELECT
key,
RANK() over w1 as r1,
DENSE_RANK() over w1 as r2,
FROM AS_TABLE([<|key:1|>, <|key:null|>, <|key:null|>, <|key:1|>, <|key:2|>])
WINDOW
w1 as (ORDER BY key ROWS BETWEEN UNBOUNDED PRECEDING AND 5 PRECEDING)
ORDER BY key;
|
