Lines Matching full:order
35 SELECT * FROM v1 ORDER BY a;
41 SELECT * FROM v1 ORDER BY a;
47 SELECT * FROM v1 ORDER BY a;
54 SELECT * FROM v1 ORDER BY a;
60 SELECT * FROM v1 ORDER BY a;
66 SELECT * FROM v1 ORDER BY a;
72 SELECT * FROM v1 ORDER BY a;
81 SELECT * FROM v1 ORDER BY a;
88 SELECT * FROM v1 ORDER BY a;
118 SELECT * FROM v2 ORDER BY x;
148 CREATE VIEW v3 AS SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY b;
158 ORDER BY x, y;
159 SELECT y FROM v4 ORDER BY y LIMIT 4;
312 SELECT * FROM v6 ORDER BY xyz;
319 SELECT * FROM v6 ORDER BY xyz;
325 SELECT * FROM v7 ORDER BY a;
351 # Tests for a bug found by Michiel de Wit involving ORDER BY in a VIEW.
358 SELECT DISTINCT count(*) FROM t2 GROUP BY a ORDER BY 1;
363 SELECT DISTINCT count(*) FROM t2 GROUP BY a ORDER BY 1 LIMIT 3;
369 SELECT DISTINCT count(*) FROM t2 GROUP BY a ORDER BY 1 LIMIT 3;
375 SELECT * FROM v9 ORDER BY 1 DESC;
381 SELECT DISTINCT a, count(*) FROM t2 GROUP BY a ORDER BY 2 LIMIT 3;
387 SELECT * FROM v10 ORDER BY 1;