Lines Matching refs:AS
53 SELECT a AS x FROM t1 ORDER BY "x";
58 SELECT a AS x FROM t1 WHERE x<'ccc' ORDER BY 1
63 SELECT a AS x FROM t1 WHERE x<'ccc' COLLATE binary ORDER BY [x]
68 SELECT a AS x FROM t1 WHERE +x<'ccc' ORDER BY 1
73 SELECT a AS x FROM t1 ORDER BY +x
86 SELECT a AS x FROM t2 WHERE x='abc';
91 SELECT a AS x FROM t2 WHERE x='abc' COLLATE nocase;
96 SELECT a AS x FROM t2 WHERE (x COLLATE nocase)='abc';
101 SELECT a COLLATE nocase AS x FROM t2 WHERE x='abc';
106 SELECT a COLLATE nocase AS x FROM t2 WHERE (x COLLATE binary)='abc';
111 SELECT a COLLATE nocase AS x FROM t2 WHERE x='abc' COLLATE binary;
121 SELECT a COLLATE nocase AS x FROM t2 WHERE 'abc'=x COLLATE binary;
