Lines Matching refs:max

102   SELECT a, max(a) FILTER (WHERE (a%2)=0) OVER w FROM t5 
107   SELECT a, max(c) OVER (ORDER BY a ROWS BETWEEN 1 PRECEDING AND 2 PRECEDING)
111   SELECT a, max(c) OVER (ORDER BY a ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING)
115   SELECT a, max(c) OVER (ORDER BY a ROWS BETWEEN 0 PRECEDING AND 0 PRECEDING)
120   SELECT a, max(c) OVER (ORDER BY a ROWS BETWEEN 2 FOLLOWING AND 1 FOLLOWING)
124   SELECT a, max(c) OVER (ORDER BY a ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING)
128   SELECT a, max(c) OVER (ORDER BY a ROWS BETWEEN 0 FOLLOWING AND 0 FOLLOWING)
151   SELECT max(c), max(b) OVER (ORDER BY b) FROM ttt GROUP BY b;
155   SELECT max(b) OVER (ORDER BY max(c)) FROM ttt GROUP BY b;
159   SELECT abs(max(b) OVER (ORDER BY b)) FROM ttt GROUP BY b;
187   SELECT max(c) OVER ($p1 $o1 $r1), 
303            max(d) OVER win,
392   SELECT sum( max(t) ) OVER () FROM t8 GROUP BY total;
399   SELECT sum( max(t) ) OVER () FROM t8;