Lines Matching refs:first_value

23 select pk, first_value(pk) over (order by pk),
25            first_value(pk) over (order by pk desc),
31        first_value(pk) over (order by pk
35        first_value(pk) over (order by pk desc
43        first_value(pk) over (order by pk desc),
48        first_value(b) over (partition by a order by pk) as fst_b,
50        first_value(c) over (partition by a order by pk) as fst_c,
52        first_value(d) over (partition by a order by pk) as fst_d,
54        first_value(e) over (partition by a order by pk) as fst_e,
67        first_value(i) OVER (order by i rows between CURRENT ROW and 1 FOLLOWING) as fst_1f,
69        first_value(i) OVER (order by i rows between 1 PRECEDING AND 1 FOLLOWING) as fst_1p1f,
71        first_value(i) OVER (order by i rows between 2 PRECEDING AND 1 PRECEDING) as fst_2p1p,
73        first_value(i) OVER (order by i rows between 1 FOLLOWING AND 2 FOLLOWING) as fst_1f2f,