Lines Matching refs:max

259   SELECT max(x) OVER abc FROM t1 WINDOW def AS (ORDER BY y);
300     max(b) OVER (ORDER BY c)
306     max(b) OVER win
342       SELECT x, y, max(y) OVER xyz FROM t4
348   SELECT x, y, max(y) OVER xyz FROM t4
354   SELECT x, y, max(y) OVER xyz FROM t4
364     SELECT x, y, max(y) OVER xyz FROM t4
372     SELECT x, y, max(y) OVER xyz FROM t4
386       SELECT a, max(d) OVER w1 FROM t1
394         SELECT a, max(d) OVER w1 FROM t1
403         SELECT a, max(d) OVER w1 FROM t1
1358   CREATE VIEW v0(c) AS SELECT max((SELECT count(a)OVER(ORDER BY 1))) FROM t0;
1363   CREATE VIEW v0(c) AS SELECT max((SELECT count(a)OVER(ORDER BY 1234))) FROM t0;
1457   SELECT count(*), max(a) OVER () FROM t1 GROUP BY c; 
1461   SELECT sum(a), max(b) OVER () FROM t1;
1622   SELECT (SELECT max(x)OVER(ORDER BY x) + min(x)OVER(ORDER BY x))
1627   SELECT (SELECT max(x)OVER(ORDER BY x) + min(x)OVER(ORDER BY x))
1881     SELECT max(y) OVER( ORDER BY (SELECT x FROM (SELECT sum(y) AS x FROM t1)))
1924 …max(x)OVER(ORDER BY x) % min(x)OVER(ORDER BY CASE x WHEN 889 THEN x WHEN x THEN x END)) FROM (SELE…
1931       (SELECT max(x)OVER(ORDER BY x) / min(x) OVER() ) 
2012   SELECT max(b) OVER(
2022         SELECT max(b) OVER(
2044   SELECT rowid, max(b COLLATE nocase)||'' 
2047   ORDER BY max(b COLLATE nocase)||'';
2051   SELECT count() OVER (), rowid, max(b COLLATE nocase)||'' 
2054   ORDER BY max(b COLLATE nocase)||'';
2058   SELECT count() OVER (), rowid, max(b COLLATE nocase)
2061   ORDER BY max(b COLLATE nocase);
2071   SELECT max(c1 COLLATE nocase) IN (SELECT 'aBCd') FROM t1;
2202    WHERE (a,1)=(SELECT 2,2 UNION SELECT sum(b),max(b) OVER(ORDER BY b) ORDER BY 2)