Lines Matching refs:q

14 #    SELECT p, max(q) FROM t1;
17 # the maximum q.
31     CREATE TABLE t1(p,q);
32     SELECT p, max(q) FROM t1;
37     SELECT p, min(q) FROM t1;
43     SELECT p, max(q) FROM t1;
48     SELECT p, min(q) FROM t1;
54     SELECT p, max(q) FROM t1;
59     SELECT p, min(q) FROM t1;
60     SELECT p FROM (SELECT p, min(q) FROM t1);
66     SELECT p, max(q) FROM t1;
67     SELECT p FROM (SELECT max(q), p FROM t1);
72     SELECT p, min(q) FROM t1;
78     SELECT p, max(q) FROM t1;
79     SELECT p FROM (SELECT max(q), p FROM t1);
84     SELECT p, min(q) FROM t1;
90     SELECT p, max(q) FROM t1;
95     SELECT p, min(q) FROM t1;
100     DELETE FROM t1 WHERE q IS NOT NULL;
101     SELECT p, max(q) FROM t1;
106     SELECT p, min(q) FROM t1;