Lines Matching refs:log
27 CREATE TABLE t1(n int, log int);
39 execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
45 lsort [execsql {SELECT DISTINCT log FROM t1}]
48 lsort [execsql {SELECT n FROM t1 WHERE log=3}]
52 SELECT DISTINCT log FROM t1
54 SELECT n FROM t1 WHERE log=3
55 ORDER BY log;
61 SELECT DISTINCT log FROM t1
63 SELECT n FROM t1 WHERE log=3
64 ORDER BY log;
72 SELECT DISTINCT log FROM t1
74 SELECT n FROM t1 WHERE log=3
75 ORDER BY log DESC;
82 SELECT DISTINCT log FROM t1
84 SELECT n FROM t1 WHERE log=2
90 SELECT DISTINCT log FROM t1
92 SELECT n FROM t1 WHERE log=2;
100 SELECT log FROM t1 WHERE n IN
101 (SELECT DISTINCT log FROM t1 UNION ALL
102 SELECT n FROM t1 WHERE log=3)
103 ORDER BY log;
113 SELECT DISTINCT log FROM t1 ORDER BY log
115 SELECT n FROM t1 WHERE log=3
116 ORDER BY log;
129 SELECT DISTINCT log FROM t1
131 SELECT n FROM t1 WHERE log=3
132 ORDER BY log;
138 SELECT log FROM t1 WHERE n IN
139 (SELECT DISTINCT log FROM t1 UNION
140 SELECT n FROM t1 WHERE log=3)
141 ORDER BY log;
147 SELECT DISTINCT log FROM t1 ORDER BY log
149 SELECT n FROM t1 WHERE log=3
150 ORDER BY log;
168 SELECT DISTINCT log FROM t1
170 SELECT n FROM t1 WHERE log=3
171 ORDER BY log;
177 SELECT DISTINCT log FROM t1
179 SELECT n FROM t1 WHERE log=3
180 ORDER BY log;
188 SELECT DISTINCT log FROM t1
190 SELECT n FROM t1 WHERE log=3
191 ORDER BY log DESC;
199 SELECT log FROM t1 WHERE n IN
200 (SELECT DISTINCT log FROM t1 EXCEPT
201 SELECT n FROM t1 WHERE log=3)
202 ORDER BY log;
208 SELECT DISTINCT log FROM t1 ORDER BY log
210 SELECT n FROM t1 WHERE log=3
211 ORDER BY log;
220 SELECT DISTINCT log FROM t1
222 SELECT n FROM t1 WHERE log=3
223 ORDER BY log;
229 SELECT DISTINCT log FROM t1
233 SELECT n FROM t1 WHERE log=3
234 ORDER BY t1.log;
241 SELECT DISTINCT log FROM t1 UNION ALL SELECT 6
243 SELECT n FROM t1 WHERE log=3
244 ORDER BY log;
252 SELECT DISTINCT log FROM t1 UNION ALL SELECT 6
254 SELECT n FROM t1 WHERE log=3
255 ORDER BY log DESC;
263 SELECT log FROM t1 WHERE n IN
264 (SELECT DISTINCT log FROM t1 INTERSECT
265 SELECT n FROM t1 WHERE log=3)
266 ORDER BY log;
272 SELECT DISTINCT log FROM t1 ORDER BY log
274 SELECT n FROM t1 WHERE log=3
275 ORDER BY log;
294 SELECT DISTINCT log FROM t2
296 SELECT n FROM t1 WHERE log=3
297 ORDER BY log;
303 SELECT DISTINCT log AS "xyzzy" FROM t1
305 SELECT n FROM t1 WHERE log=3
312 SELECT DISTINCT log AS xyzzy FROM t1
314 SELECT n FROM t1 WHERE log=3
321 SELECT DISTINCT log FROM t1
323 SELECT n FROM t1 WHERE log=3
330 SELECT DISTINCT log FROM t1
332 SELECT n FROM t1 WHERE log=3
339 SELECT DISTINCT log FROM t1
341 SELECT n FROM t1 WHERE log=3
348 SELECT DISTINCT log FROM t1
350 SELECT n FROM t1 WHERE log=3
351 ORDER BY log;
356 SELECT DISTINCT log FROM t1
358 SELECT n FROM t1 WHERE log=3
364 SELECT DISTINCT log FROM t1
366 SELECT n FROM t1 WHERE log=3
372 SELECT DISTINCT 1, log FROM t1
374 SELECT 2, n FROM t1 WHERE log=3
380 SELECT DISTINCT 1, log FROM t1
382 SELECT 2, n FROM t1 WHERE log=3
388 SELECT DISTINCT 1, log FROM t1
390 SELECT 2, n FROM t1 WHERE log=3
396 SELECT DISTINCT log, n FROM t1
398 SELECT n FROM t1 WHERE log=3
399 ORDER BY log;
410 SELECT log FROM t1 WHERE n=2
412 SELECT log FROM t1 WHERE n=3
414 SELECT log FROM t1 WHERE n=4
416 SELECT log FROM t1 WHERE n=5
417 ORDER BY log;
424 SELECT log, count(*) as cnt FROM t1 GROUP BY log
426 SELECT log, n FROM t1 WHERE n=7
427 ORDER BY cnt, log;
432 SELECT log, count(*) FROM t1 GROUP BY log
434 SELECT log, n FROM t1 WHERE n=7
435 ORDER BY count(*), log;
497 CREATE TABLE t2 AS SELECT log AS 'x', count(*) AS 'y' FROM t1 GROUP BY log;
507 } {n 1 log 0 n 2 log 1 n 3 log 2 n 4 log 2 n 5 log 3}
513 } {n 6 log 3 n 7 log 3}
519 } {n 1 log 0 n 2 log 1}
655 SELECT DISTINCT log FROM t1 ORDER BY log
660 SELECT DISTINCT log FROM t1 ORDER BY log LIMIT 4
665 SELECT DISTINCT log FROM t1 ORDER BY log LIMIT 0
670 SELECT DISTINCT log FROM t1 ORDER BY log LIMIT -1
675 SELECT DISTINCT log FROM t1 ORDER BY log LIMIT -1 OFFSET 2
680 SELECT DISTINCT log FROM t1 ORDER BY log LIMIT 3 OFFSET 2
685 SELECT DISTINCT log FROM t1 ORDER BY +log LIMIT 3 OFFSET 20
690 SELECT DISTINCT log FROM t1 ORDER BY log LIMIT 0 OFFSET 3
695 SELECT DISTINCT max(n), log FROM t1 ORDER BY +log; -- LIMIT 2 OFFSET 1