Lines Matching refs:over
24 lead(pk) over (order by pk),
25 lead(pk, 1) over (order by pk),
26 lead(pk, 2) over (order by pk),
27 lead(pk, 0) over (order by pk),
28 lead(pk, -1) over (order by pk),
29 lead(pk, -2) over (order by pk)
34 lag(pk) over (order by pk),
35 lag(pk, 1) over (order by pk),
36 lag(pk, 2) over (order by pk),
37 lag(pk, 0) over (order by pk),
38 lag(pk, -1) over (order by pk),
39 lag(pk, -2) over (order by pk)
44 lag(pk, pk - 2) over (order by pk),
45 lead(pk, pk - 2) over (order by pk)
50 lag(pk, pk + 2) over (order by pk),
51 lead(pk, pk + 2) over (order by pk)
56 lead(pk) over (partition by a order by pk),
57 lead(pk, 1) over (partition by a order by pk),
58 lead(pk, 2) over (partition by a order by pk),
59 lead(pk, 0) over (partition by a order by pk),
60 lead(pk, -1) over (partition by a order by pk),
61 lead(pk, -2) over (partition by a order by pk)
66 lag(pk) over (partition by a order by pk),
67 lag(pk, 1) over (partition by a order by pk),
68 lag(pk, 2) over (partition by a order by pk),
69 lag(pk, 0) over (partition by a order by pk),
70 lag(pk, -1) over (partition by a order by pk),
71 lag(pk, -2) over (partition by a order by pk)
76 lag(pk, pk - 2) over (partition by a order by pk),
77 lead(pk, pk - 2) over (partition by a order by pk),
78 lag(pk, a - 2) over (partition by a order by pk),
79 lead(pk, a - 2) over (partition by a order by pk)
84 lag(pk, pk + 2) over (partition by a order by pk),
85 lead(pk, pk + 2) over (partition by a order by pk),
86 lag(pk, a + 2) over (partition by a order by pk),
87 lead(pk, a + 2) over (partition by a order by pk)
92 lag(a) over (partition by a order by pk),
93 lag(b) over (partition by a order by pk),
94 lag(c) over (partition by a order by pk),
95 lag(d) over (partition by a order by pk),
96 lag(e) over (partition by a order by pk)
101 lag(a + b) over (partition by a order by pk)
106 lag(a + b) over (partition by a order by pk) + pk
115 lag(pk, 1) over ()
120 lead(pk, 1) over ()