Lines Matching refs:max

60   count { SELECT max(y) FROM t1 WHERE x = '2'; }
65   count   { SELECT max(y) FROM t1 WHERE x = '2'; }
70   count   { SELECT max(y) FROM t1 WHERE x = '2'; }
75   count   { SELECT max(y) FROM t1 WHERE x = '2'; }
78   count   { SELECT max(y) FROM t1 WHERE x = '2' AND y != 'V'; }
81   count   { SELECT max(y) FROM t1 WHERE x = '2' AND y < 'V'; }
84   count   { SELECT max(y) FROM t1 WHERE x = '2' AND z != 'five'; }
127   count   { SELECT max(y) FROM t1; }
130   # Index i1 optimizes the max(y)
132   count   { SELECT max(y) FROM t1; }
135   # Index i1 optimizes the max(y)
138   count   { SELECT max(y) FROM t1; }
228     SELECT max(x) FROM t4;
233     SELECT max(x COLLATE nocase) FROM t4;
238     SELECT max(x), max(x COLLATE nocase) FROM t4;
243     SELECT max(x COLLATE binary), max(x COLLATE nocase) FROM t4;
248     SELECT max(x COLLATE nocase), max(x COLLATE rtrim) FROM t4;
253     SELECT max(x COLLATE nocase), max(x) FROM t4;