Lines Matching refs:log
30 CREATE TABLE t1(n int, log int);
36 execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
42 lsort [execsql {SELECT DISTINCT log FROM t1}]
45 lsort [execsql {SELECT n FROM t1 WHERE log=3}]
49 SELECT DISTINCT log FROM t1
51 SELECT n FROM t1 WHERE log=3
52 ORDER BY log;
58 SELECT DISTINCT log FROM t1
60 SELECT n FROM t1 WHERE log=3
61 ORDER BY log;
69 SELECT DISTINCT log FROM t1
71 SELECT n FROM t1 WHERE log=3
72 ORDER BY log DESC;
79 SELECT DISTINCT log FROM t1
81 SELECT n FROM t1 WHERE log=2
87 SELECT DISTINCT log FROM t1
89 SELECT n FROM t1 WHERE log=2;
96 SELECT log FROM t1 WHERE n IN
97 (SELECT DISTINCT log FROM t1 UNION ALL
98 SELECT n FROM t1 WHERE log=3)
99 ORDER BY log;
104 SELECT DISTINCT log FROM t1 ORDER BY log
106 SELECT n FROM t1 WHERE log=3
107 ORDER BY log;
116 SELECT DISTINCT log FROM t1
118 SELECT n FROM t1 WHERE log=3
119 ORDER BY log;
124 SELECT log FROM t1 WHERE n IN
125 (SELECT DISTINCT log FROM t1 UNION
126 SELECT n FROM t1 WHERE log=3)
127 ORDER BY log;
132 SELECT DISTINCT log FROM t1 ORDER BY log
134 SELECT n FROM t1 WHERE log=3
135 ORDER BY log;
144 SELECT DISTINCT log FROM t1
146 SELECT n FROM t1 WHERE log=3
147 ORDER BY log;
153 SELECT DISTINCT log FROM t1
155 SELECT n FROM t1 WHERE log=3
156 ORDER BY log;
164 SELECT DISTINCT log FROM t1
166 SELECT n FROM t1 WHERE log=3
167 ORDER BY log DESC;
174 SELECT log FROM t1 WHERE n IN
175 (SELECT DISTINCT log FROM t1 EXCEPT
176 SELECT n FROM t1 WHERE log=3)
177 ORDER BY log;
182 SELECT DISTINCT log FROM t1 ORDER BY log
184 SELECT n FROM t1 WHERE log=3
185 ORDER BY log;
194 SELECT DISTINCT log FROM t1
196 SELECT n FROM t1 WHERE log=3
197 ORDER BY log;
202 SELECT DISTINCT log FROM t1 UNION ALL SELECT 6
204 SELECT n FROM t1 WHERE log=3
205 ORDER BY log;
211 SELECT DISTINCT log FROM t1 UNION ALL SELECT 6
213 SELECT n FROM t1 WHERE log=3
214 ORDER BY log;
222 SELECT DISTINCT log FROM t1 UNION ALL SELECT 6
224 SELECT n FROM t1 WHERE log=3
225 ORDER BY log DESC;
232 SELECT log FROM t1 WHERE n IN
233 (SELECT DISTINCT log FROM t1 INTERSECT
234 SELECT n FROM t1 WHERE log=3)
235 ORDER BY log;
240 SELECT DISTINCT log FROM t1 ORDER BY log
242 SELECT n FROM t1 WHERE log=3
243 ORDER BY log;
252 SELECT DISTINCT log FROM t2
254 SELECT n FROM t1 WHERE log=3
255 ORDER BY log;
261 SELECT DISTINCT log AS "xyzzy" FROM t1
263 SELECT n FROM t1 WHERE log=3
270 SELECT DISTINCT log AS xyzzy FROM t1
272 SELECT n FROM t1 WHERE log=3
279 SELECT DISTINCT log FROM t1
281 SELECT n FROM t1 WHERE log=3
288 SELECT DISTINCT log FROM t1
290 SELECT n FROM t1 WHERE log=3
297 SELECT DISTINCT log FROM t1
299 SELECT n FROM t1 WHERE log=3
306 SELECT DISTINCT log FROM t1
308 SELECT n FROM t1 WHERE log=3
309 ORDER BY log;
314 SELECT DISTINCT log FROM t1
316 SELECT n FROM t1 WHERE log=3
322 SELECT DISTINCT log FROM t1
324 SELECT n FROM t1 WHERE log=3
330 SELECT DISTINCT 1, log FROM t1
332 SELECT 2, n FROM t1 WHERE log=3
338 SELECT DISTINCT 1, log FROM t1
340 SELECT 2, n FROM t1 WHERE log=3
346 SELECT DISTINCT 1, log FROM t1
348 SELECT 2, n FROM t1 WHERE log=3
354 SELECT DISTINCT log, n FROM t1
356 SELECT n FROM t1 WHERE log=3
357 ORDER BY log;
363 SELECT log FROM t1 WHERE n=2
365 SELECT log FROM t1 WHERE n=3
367 SELECT log FROM t1 WHERE n=4
369 SELECT log FROM t1 WHERE n=5
370 ORDER BY log;
377 SELECT log, count(*) as cnt FROM t1 GROUP BY log
379 SELECT log, n FROM t1 WHERE n=7
380 ORDER BY cnt, log;
385 SELECT log, count(*) FROM t1 GROUP BY log
387 SELECT log, n FROM t1 WHERE n=7
388 ORDER BY count(*), log;
448 CREATE TABLE t2 AS SELECT log AS 'x', count(*) AS 'y' FROM t1 GROUP BY log;
457 } {n 1 log 0 n 2 log 1 n 3 log 2 n 4 log 2 n 5 log 3}
463 } {n 6 log 3 n 7 log 3}
469 } {n 1 log 0 n 2 log 1}