Lines Matching refs:max

168      (SELECT value1 as xyz, max(x1) AS pqr
174      (SELECT value1 as xyz, max(x1) AS pqr
187     SELECT (SELECT sum(value2=value1) FROM t2), max(value1)
207     SELECT max(value1), (SELECT count(*) FROM t2 WHERE value2=max(value1))
214     SELECT max(value1), (SELECT count(*) FROM t2 WHERE value2=value1)
229      WHERE value1 IN (SELECT max(value1) FROM t1 GROUP BY id1);
235     SELECT max(value1), (SELECT sum(value2=max(value1)) FROM t2)
239 } {1 {misuse of aggregate function max()}}
242     SELECT max(value1), (SELECT sum(value2=value1) FROM t2)
271   SELECT max((SELECT a FROM (SELECT count(*) AS a FROM ty) AS s)) FROM tx;
302     SELECT max(b) LIMIT (