blob: d2533c062bfbefa446496787fa2fd2452feb38e6 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
/* syntax version 1 */
/* postgres can not */
use plato;
select
value,
max(value) over (partition by cast(TableName() as Utf8)),
cast(TableName() as Utf8),
from Input order by value;
select
value,
max(value) over (order by cast(TableName() as Utf8) rows between unbounded preceding and unbounded following),
cast(TableName() as Utf8),
from Input order by value;
|