Lines Matching refs:log

32   CREATE TABLE t1(n int, log int);
38 execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
44 lsort [execsql {SELECT DISTINCT log FROM t1}]
47 lsort [execsql {SELECT n FROM t1 WHERE log=3}]
51 SELECT DISTINCT log FROM t1
53 SELECT n FROM t1 WHERE log=3
54 ORDER BY log;
60 SELECT DISTINCT log FROM t1
62 SELECT n FROM t1 WHERE log=3
63 ORDER BY log;
71 SELECT DISTINCT log FROM t1
73 SELECT n FROM t1 WHERE log=3
74 ORDER BY log DESC;
81 SELECT DISTINCT log FROM t1
83 SELECT n FROM t1 WHERE log=2
89 SELECT DISTINCT log FROM t1
91 SELECT n FROM t1 WHERE log=2;
98 SELECT log FROM t1 WHERE n IN
99 (SELECT DISTINCT log FROM t1 UNION ALL
100 SELECT n FROM t1 WHERE log=3)
101 ORDER BY log;
106 SELECT DISTINCT log FROM t1 ORDER BY log
108 SELECT n FROM t1 WHERE log=3
109 ORDER BY log;
118 SELECT DISTINCT log FROM t1
120 SELECT n FROM t1 WHERE log=3
121 ORDER BY log;
126 SELECT log FROM t1 WHERE n IN
127 (SELECT DISTINCT log FROM t1 UNION
128 SELECT n FROM t1 WHERE log=3)
129 ORDER BY log;
134 SELECT DISTINCT log FROM t1 ORDER BY log
136 SELECT n FROM t1 WHERE log=3
137 ORDER BY log;
146 SELECT DISTINCT log FROM t1
148 SELECT n FROM t1 WHERE log=3
149 ORDER BY log;
155 SELECT DISTINCT log FROM t1
157 SELECT n FROM t1 WHERE log=3
158 ORDER BY log;
166 SELECT DISTINCT log FROM t1
168 SELECT n FROM t1 WHERE log=3
169 ORDER BY log DESC;
176 SELECT log FROM t1 WHERE n IN
177 (SELECT DISTINCT log FROM t1 EXCEPT
178 SELECT n FROM t1 WHERE log=3)
179 ORDER BY log;
184 SELECT DISTINCT log FROM t1 ORDER BY log
186 SELECT n FROM t1 WHERE log=3
187 ORDER BY log;
196 SELECT DISTINCT log FROM t1
198 SELECT n FROM t1 WHERE log=3
199 ORDER BY log;
204 SELECT DISTINCT log FROM t1 UNION ALL SELECT 6
206 SELECT n FROM t1 WHERE log=3
207 ORDER BY log;
213 SELECT DISTINCT log FROM t1 UNION ALL SELECT 6
215 SELECT n FROM t1 WHERE log=3
216 ORDER BY log;
224 SELECT DISTINCT log FROM t1 UNION ALL SELECT 6
226 SELECT n FROM t1 WHERE log=3
227 ORDER BY log DESC;
234 SELECT log FROM t1 WHERE n IN
235 (SELECT DISTINCT log FROM t1 INTERSECT
236 SELECT n FROM t1 WHERE log=3)
237 ORDER BY log;
242 SELECT DISTINCT log FROM t1 ORDER BY log
244 SELECT n FROM t1 WHERE log=3
245 ORDER BY log;
254 SELECT DISTINCT log FROM t2
256 SELECT n FROM t1 WHERE log=3
257 ORDER BY log;
263 SELECT DISTINCT log AS "xyzzy" FROM t1
265 SELECT n FROM t1 WHERE log=3
272 SELECT DISTINCT log AS xyzzy FROM t1
274 SELECT n FROM t1 WHERE log=3
281 SELECT DISTINCT log FROM t1
283 SELECT n FROM t1 WHERE log=3
290 SELECT DISTINCT log FROM t1
292 SELECT n FROM t1 WHERE log=3
299 SELECT DISTINCT log FROM t1
301 SELECT n FROM t1 WHERE log=3
308 SELECT DISTINCT log FROM t1
310 SELECT n FROM t1 WHERE log=3
311 ORDER BY log;
316 SELECT DISTINCT log FROM t1
318 SELECT n FROM t1 WHERE log=3
324 SELECT DISTINCT log FROM t1
326 SELECT n FROM t1 WHERE log=3
332 SELECT DISTINCT 1, log FROM t1
334 SELECT 2, n FROM t1 WHERE log=3
340 SELECT DISTINCT 1, log FROM t1
342 SELECT 2, n FROM t1 WHERE log=3
348 SELECT DISTINCT 1, log FROM t1
350 SELECT 2, n FROM t1 WHERE log=3
356 SELECT DISTINCT log, n FROM t1
358 SELECT n FROM t1 WHERE log=3
359 ORDER BY log;
365 SELECT log FROM t1 WHERE n=2
367 SELECT log FROM t1 WHERE n=3
369 SELECT log FROM t1 WHERE n=4
371 SELECT log FROM t1 WHERE n=5
372 ORDER BY log;
379 SELECT log, count(*) as cnt FROM t1 GROUP BY log
381 SELECT log, n FROM t1 WHERE n=7
382 ORDER BY cnt, log;
387 SELECT log, count(*) FROM t1 GROUP BY log
389 SELECT log, n FROM t1 WHERE n=7
390 ORDER BY count(*), log;
450 CREATE TABLE t2 AS SELECT log AS 'x', count(*) AS 'y' FROM t1 GROUP BY log;
459 } {n 1 log 0 n 2 log 1 n 3 log 2 n 4 log 2 n 5 log 3}
465 } {n 6 log 3 n 7 log 3}
471 } {n 1 log 0 n 2 log 1}