Lines Matching refs:t3
110 CREATE TABLE t3(x int);
111 INSERT INTO t3 SELECT a FROM t1 UNION ALL SELECT b FROM t1;
112 SELECT * FROM t3 ORDER BY x;
117 SELECT sum(x) FROM (SELECT x FROM t3 ORDER BY x LIMIT 2);
122 SELECT sum(x) FROM (SELECT x FROM t3 ORDER BY x DESC LIMIT 2);
127 SELECT (SELECT x FROM t3 ORDER BY x);
132 SELECT (SELECT x FROM t3 ORDER BY x DESC);
137 SELECT (SELECT x FROM t3 ORDER BY x LIMIT 1);
142 SELECT (SELECT x FROM t3 ORDER BY x DESC LIMIT 1);
147 SELECT (SELECT x FROM t3 ORDER BY x LIMIT 1 OFFSET 2);
152 SELECT (SELECT x FROM t3 ORDER BY x DESC LIMIT 1 OFFSET 2);