github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/window.ref.golden (about) 1 1: 2 - 3 SELECT 4 sum( 5 a 6 ) OVER w, 7 avg( 8 b 9 ) OVER ( 10 PARTITION BY 11 c 12 ORDER BY 13 d 14 ROWS 15 e PRECEDING 16 ), 17 min( 18 f 19 ) OVER ( 20 ORDER BY 21 g 22 RANGE 23 BETWEEN 24 UNBOUNDED PRECEDING 25 AND 26 h FOLLOWING EXCLUDE TIES 27 ) 28 FROM 29 t 30 WINDOW 31 w AS ( 32 PARTITION BY 33 i 34 GROUPS 35 BETWEEN 36 j PRECEDING 37 AND 38 CURRENT ROW EXCLUDE NO OTHERS 39 ) 40 41 17: 42 ----------------- 43 SELECT 44 sum( 45 a 46 ) OVER w, 47 avg(b) OVER ( 48 PARTITION BY 49 c 50 ORDER BY 51 d 52 ROWS 53 e PRECEDING 54 ), 55 min(f) OVER ( 56 ORDER BY 57 g 58 RANGE 59 BETWEEN 60 UNBOUNDED PRECEDING 61 AND 62 h FOLLOWING EXCLUDE TIES 63 ) 64 FROM 65 t 66 WINDOW 67 w AS ( 68 PARTITION BY 69 i 70 GROUPS 71 BETWEEN 72 j PRECEDING 73 AND 74 CURRENT ROW EXCLUDE NO OTHERS 75 ) 76 77 18: 78 ------------------ 79 SELECT 80 sum(a) OVER w, 81 avg(b) OVER ( 82 PARTITION BY 83 c 84 ORDER BY 85 d 86 ROWS 87 e PRECEDING 88 ), 89 min(f) OVER ( 90 ORDER BY 91 g 92 RANGE 93 BETWEEN 94 UNBOUNDED PRECEDING 95 AND 96 h FOLLOWING EXCLUDE TIES 97 ) 98 FROM 99 t 100 WINDOW 101 w AS ( 102 PARTITION BY 103 i 104 GROUPS 105 BETWEEN 106 j PRECEDING 107 AND 108 CURRENT ROW EXCLUDE NO OTHERS 109 ) 110 111 50: 112 -------------------------------------------------- 113 SELECT 114 sum(a) OVER w, 115 avg(b) OVER ( 116 PARTITION BY c ORDER BY d ROWS e PRECEDING 117 ), 118 min(f) OVER ( 119 ORDER BY 120 g 121 RANGE 122 BETWEEN 123 UNBOUNDED PRECEDING 124 AND 125 h FOLLOWING EXCLUDE TIES 126 ) 127 FROM 128 t 129 WINDOW 130 w AS ( 131 PARTITION BY 132 i 133 GROUPS 134 BETWEEN 135 j PRECEDING 136 AND 137 CURRENT ROW EXCLUDE NO OTHERS 138 ) 139 140 61: 141 ------------------------------------------------------------- 142 SELECT 143 sum(a) OVER w, 144 avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), 145 min(f) OVER ( 146 ORDER BY 147 g 148 RANGE 149 BETWEEN 150 UNBOUNDED PRECEDING 151 AND 152 h FOLLOWING EXCLUDE TIES 153 ) 154 FROM 155 t 156 WINDOW 157 w AS ( 158 PARTITION BY 159 i 160 GROUPS 161 BETWEEN 162 j PRECEDING 163 AND 164 CURRENT ROW EXCLUDE NO OTHERS 165 ) 166 167 65: 168 ----------------------------------------------------------------- 169 SELECT 170 sum(a) OVER w, 171 avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), 172 min(f) OVER ( 173 ORDER BY 174 g 175 RANGE 176 BETWEEN 177 UNBOUNDED PRECEDING 178 AND 179 h FOLLOWING EXCLUDE TIES 180 ) 181 FROM 182 t 183 WINDOW 184 w AS ( 185 PARTITION BY 186 i 187 GROUPS 188 BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS 189 ) 190 191 68: 192 -------------------------------------------------------------------- 193 SELECT 194 sum(a) OVER w, 195 avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), 196 min(f) OVER ( 197 ORDER BY 198 g 199 RANGE 200 BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES 201 ) 202 FROM 203 t 204 WINDOW 205 w AS ( 206 PARTITION BY 207 i 208 GROUPS 209 BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS 210 ) 211 212 81: 213 --------------------------------------------------------------------------------- 214 SELECT 215 sum(a) OVER w, 216 avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), 217 min(f) OVER ( 218 ORDER BY g RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES 219 ) 220 FROM 221 t 222 WINDOW 223 w AS ( 224 PARTITION BY 225 i 226 GROUPS 227 BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS 228 ) 229 230 83: 231 ----------------------------------------------------------------------------------- 232 SELECT 233 sum(a) OVER w, 234 avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), 235 min(f) OVER ( 236 ORDER BY g RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES 237 ) 238 FROM 239 t 240 WINDOW 241 w AS ( 242 PARTITION BY i GROUPS BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS 243 ) 244 245 86: 246 -------------------------------------------------------------------------------------- 247 SELECT 248 sum(a) OVER w, 249 avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), 250 min(f) OVER ( 251 ORDER BY g RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES 252 ) 253 FROM 254 t 255 WINDOW 256 w AS (PARTITION BY i GROUPS BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS) 257 258 91: 259 ------------------------------------------------------------------------------------------- 260 SELECT 261 sum(a) OVER w, 262 avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), 263 min(f) OVER (ORDER BY g RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES) 264 FROM 265 t 266 WINDOW 267 w AS (PARTITION BY i GROUPS BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS) 268 269 164: 270 -------------------------------------------------------------------------------------------------------------------------------------------------------------------- 271 SELECT 272 sum(a) OVER w, avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), min(f) OVER (ORDER BY g RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES) 273 FROM 274 t 275 WINDOW 276 w AS (PARTITION BY i GROUPS BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS) 277 278 264: 279 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 280 SELECT sum(a) OVER w, avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), min(f) OVER (ORDER BY g RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES) FROM t WINDOW w AS (PARTITION BY i GROUPS BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS)