Lines Matching refs:AS

34     SELECT 1 AS y FROM t1, t2 ORDER BY y;
39     SELECT 1 AS yy FROM t1, t2 ORDER BY y;
45     SELECT x AS y FROM t3 ORDER BY y;
50     SELECT x AS yy FROM t3 ORDER BY y;
59     SELECT x AS yy FROM t3 ORDER BY yy;
64     SELECT x AS yy FROM t3 ORDER BY 1;
77     SELECT 2 AS y FROM t1, t2 ORDER BY y COLLATE nocase;
82     SELECT 2 AS yy FROM t1, t2 ORDER BY y COLLATE nocase;
87     SELECT x AS y FROM t3 ORDER BY y COLLATE nocase;
92     SELECT x AS yy FROM t3 ORDER BY y COLLATE nocase;
97     SELECT x AS yy FROM t3 ORDER BY yy COLLATE nocase;
102     SELECT x AS yy FROM t3 ORDER BY 1 COLLATE nocase;
115     SELECT 3 AS y FROM t1, t2 ORDER BY +y;
120     SELECT 2 AS yy FROM t1, t2 ORDER BY +y;
125     SELECT x AS y FROM t3 ORDER BY +y;
130     SELECT x AS yy FROM t3 ORDER BY +y;
135     SELECT x AS yy FROM t3 ORDER BY +yy
149   SELECT '1', substr(m,2) AS m FROM t4 ORDER BY m;
150   SELECT '2', substr(m,2) AS m FROM t4 ORDER BY m COLLATE binary;
151   SELECT '3', substr(m,2) AS m FROM t4 ORDER BY lower(m);
166   SELECT count(*), substr(m,2,1) AS m FROM t5 GROUP BY m ORDER BY 1, 2;
172   SELECT count(*), substr(m,2,1) AS mx FROM t5 GROUP BY m ORDER BY 1, 2;
179   SELECT count(*), substr(m,2,1) AS mx FROM t5 GROUP BY mx ORDER BY 1, 2;
182   SELECT count(*), substr(m,2,1) AS mx FROM t5
194   SELECT min(name) AS name FROM t61 GROUP BY lower(name); 
201        NULLIF(name,'abc') AS name
207   SELECT 2 AS x WHERE (SELECT x AS y WHERE 3>y);
210   SELECT 2 AS x WHERE (SELECT x AS y WHERE 1>y);