Lines Matching refs:t3
108 CREATE TABLE t3(x int);
109 INSERT INTO t3 SELECT a FROM t1 UNION ALL SELECT b FROM t1;
110 SELECT * FROM t3 ORDER BY x;
115 SELECT sum(x) FROM (SELECT x FROM t3 ORDER BY x LIMIT 2);
120 SELECT sum(x) FROM (SELECT x FROM t3 ORDER BY x DESC LIMIT 2);
125 SELECT (SELECT x FROM t3 ORDER BY x);
130 SELECT (SELECT x FROM t3 ORDER BY x DESC);
135 SELECT (SELECT x FROM t3 ORDER BY x LIMIT 1);
140 SELECT (SELECT x FROM t3 ORDER BY x DESC LIMIT 1);
145 SELECT (SELECT x FROM t3 ORDER BY x LIMIT 1 OFFSET 2);
150 SELECT (SELECT x FROM t3 ORDER BY x DESC LIMIT 1 OFFSET 2);