Lines Matching refs:count

46 do_execsql_test 1.1 { SELECT count(*) FROM t1, t2; } 6
54   SELECT count(*) FROM t1, t2;
63   SELECT count(*) FROM t1, t2 WHERE t2.rowid>1;
72   SELECT count(*) FROM t1, t2 WHERE t2.rowid>1;
203   SELECT count(*) FROM a1 WHERE (a BETWEEN 4 AND 12) OR (b BETWEEN 40 AND 60)
213   SELECT count(*) FROM a1 AS x, a1 AS y 
224   SELECT count(*) FROM a1 WHERE a IN (1, 5, 10, 15);
232   SELECT count(*) FROM a1 WHERE rowid IN (1, 5, 10, 15);
312   SELECT count(*) FROM t1 WHERE a IN (SELECT b FROM t1 AS ii)
322   SELECT count(*) FROM t1 WHERE a IN (0, 1)
330   SELECT count(*) FROM t2 WHERE y = 'j';
333   SELECT count(*) FROM t2 WHERE y = 'j';
341   SELECT count(*) FROM t1, t2 WHERE y = c;
348   SELECT count(*) FROM t1, t2 WHERE y = c;
358   SELECT count(*) FROM t1, t3 WHERE y = c;
365   SELECT count(*) FROM t1, t3 WHERE y = c;
391     SELECT count(*) FROM ft1 WHERE ft1 MATCH 'd'