Lines Matching refs:d

24   CREATE TABLE t1(a INTEGER PRIMARY KEY, b CHAR(1), d FLOAT);
36   SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
38      (ORDER BY d DESC NULLS LAST
40   ORDER BY +d DESC NULLS LAST, +a;
52   SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
54      (ORDER BY d DESC NULLS FIRST
56   ORDER BY +d DESC NULLS FIRST, +a;
68   SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
70      (ORDER BY d DESC NULLS LAST
72   ORDER BY +d DESC NULLS LAST, +a;
84   SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
86      (ORDER BY d DESC NULLS FIRST
88   ORDER BY +d DESC NULLS FIRST, +a;
100   SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
102      (ORDER BY d DESC NULLS LAST
104   ORDER BY +d DESC NULLS LAST, +a;
116   SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
118      (ORDER BY d DESC NULLS FIRST
120   ORDER BY +d DESC NULLS FIRST, +a;
132   SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
134      (ORDER BY d DESC NULLS LAST
136   ORDER BY +d DESC NULLS LAST, +a;
148   SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
150      (ORDER BY d DESC NULLS FIRST
152   ORDER BY +d DESC NULLS FIRST, +a;
164   SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
166      (ORDER BY d DESC NULLS LAST
168   ORDER BY +d DESC NULLS LAST, +a;
180   SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
182      (ORDER BY d DESC NULLS FIRST
184   ORDER BY +d DESC NULLS FIRST, +a;
196   SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
198      (ORDER BY d DESC NULLS LAST
200   ORDER BY +d DESC NULLS LAST, +a;
212   SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
214      (ORDER BY d DESC NULLS FIRST
216   ORDER BY +d DESC NULLS FIRST, +a;
229   SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
231      (ORDER BY d DESC NULLS LAST
233   ORDER BY +d DESC NULLS LAST, +a;
245   SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
247      (ORDER BY d DESC NULLS FIRST
249   ORDER BY +d DESC NULLS FIRST, +a;
261   SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
263      (ORDER BY d DESC NULLS LAST
265   ORDER BY +d DESC NULLS LAST, +a;
277   SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
279      (ORDER BY d DESC NULLS FIRST
281   ORDER BY +d DESC NULLS FIRST, +a;
293   SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
295      (ORDER BY d DESC NULLS FIRST
297   ORDER BY +d DESC NULLS FIRST, +a;