blob: c6cb84badb99c9f359a0f33bd373775e8324ce40 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
|
PRAGMA warning("disable", "4520");
PRAGMA AnsiRankForNullableKeys;
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;
|
