Lines Matching refs:SELECT
74 SELECT c2 FROM collate1t1 ORDER BY 1;
79 SELECT c2 FROM collate1t1 ORDER BY 1 COLLATE hex;
84 SELECT c2 FROM collate1t1 ORDER BY 1 COLLATE hex DESC;
89 SELECT c2 FROM collate1t1 ORDER BY 1 COLLATE hex ASC;
94 SELECT c2 COLLATE hex FROM collate1t1 ORDER BY 1
99 SELECT c2 COLLATE hex FROM collate1t1 ORDER BY 1 ASC
104 SELECT c2 COLLATE hex FROM collate1t1 ORDER BY 1 DESC
126 SELECT c1, c2 FROM collate1t1 ORDER BY 1 COLLATE numeric, 2 COLLATE hex;
131 SELECT c1, c2 FROM collate1t1 ORDER BY 1 COLLATE binary, 2 COLLATE hex;
136 SELECT c1, c2 FROM collate1t1 ORDER BY 1 COLLATE binary DESC, 2 COLLATE hex;
141 SELECT c1, c2 FROM collate1t1
147 SELECT c1, c2 FROM collate1t1
153 SELECT c1 COLLATE numeric, c2 FROM collate1t1
159 SELECT c1 COLLATE hex, c2 FROM collate1t1
165 SELECT c1, c2 COLLATE hex FROM collate1t1
171 SELECT c1 COLLATE numeric, c2 COLLATE hex
178 SELECT c1 COLLATE binary, c2 COLLATE hex
185 SELECT c1, c2
191 SELECT c1 COLLATE binary, c2 COLLATE hex
198 SELECT c1 COLLATE hex, c2 COLLATE binary
221 SELECT * FROM collate1t1 ORDER BY a;
227 SELECT * FROM collate1t1 ORDER BY 1;
232 SELECT * FROM collate1t1 ORDER BY collate1t1.a;
237 SELECT * FROM collate1t1 ORDER BY main.collate1t1.a;
242 SELECT a as c1, b as c2 FROM collate1t1 ORDER BY c1;
247 SELECT a as c1, b as c2 FROM collate1t1 ORDER BY c1 COLLATE binary;
252 SELECT a COLLATE binary as c1, b as c2
278 SELECT c1 FROM collate1t1 ORDER BY 1;
283 SELECT c2 FROM collate1t1 ORDER BY 1;
288 SELECT c2+0 FROM collate1t1 ORDER BY 1;
293 SELECT c1||'' FROM collate1t1 ORDER BY 1;
298 SELECT (c1||'') COLLATE numeric FROM collate1t1 ORDER BY 1;
