Lines Matching refs:max

62   execsql {SELECT *, min(f1,f2), max(f1,f2) FROM test1}
93   execsql {SELECT max(test1.f1,test2.r1), min(test1.f2,test2.r2)
97   execsql {SELECT min(test1.f1,test2.r1), max(test1.f2,test2.r2)
179   set v [catch {execsql {SELECT max(f1,f2) FROM test1}} msg]
191   execsql {SELECT coalesce(max(a),'xyzzy') FROM t3}
194   execsql {SELECT max(coalesce(a,'xyzzy')) FROM t3}
232      SELECT min(f1) AS m FROM test1 GROUP BY f1 HAVING max(m+5)<10
239      HAVING max(m+5)<10
249     SELECT count(a) AS cn FROM tkt2526 GROUP BY a HAVING cn<max(cn)
284   set v [catch {execsql {SELECT f1 FROM test1 WHERE max(f1,f2)!=11}} msg]
407   set v [catch {execsql {SELECT max(f1) FROM test1 ORDER BY f2}} msg]
752            coalesce(max(f1/(f1-33),6),'z')
759     SELECT min(1,2,3), -max(1,2,3)
908       SELECT t3.* FROM t3, (SELECT max(a), max(b) FROM t4)
913       SELECT t3.* FROM (SELECT max(a), max(b) FROM t4), t3
918       SELECT * FROM t3, (SELECT max(a), max(b) FROM t4) AS 'tx'
920   } {a 1 b 2 max(a) 3 max(b) 4}
923       SELECT y.*, t3.* FROM t3, (SELECT max(a), max(b) FROM t4) AS y
925   } {max(a) 3 max(b) 4 a 1 b 2}
1013         INSERT INTO abc SELECT a+(select max(a) FROM abc), 
1014             b+(select max(a) FROM abc), c+(select max(a) FROM abc) FROM abc;
1201   SELECT ifnull(a, max((SELECT 123))), count(a) FROM t1 ;