Lines Matching refs:count

59   execsql {SELECT count(*) FROM (SELECT y FROM t1)}
62   execsql {SELECT count(*) FROM (SELECT DISTINCT y FROM t1)}
65   execsql {SELECT count(*) FROM (SELECT DISTINCT * FROM (SELECT y FROM t1))}
68   execsql {SELECT count(*) FROM (SELECT * FROM (SELECT DISTINCT y FROM t1))}
74     FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
81     SELECT a.y, a.[count(*)], [max(x)], [count(*)]
82     FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
90     FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
98     FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
115   execsql {SELECT count(*) FROM (SELECT b FROM t2)}
118   execsql {SELECT count(*) FROM (SELECT DISTINCT b FROM t2)}
121   execsql {SELECT count(*) FROM (SELECT DISTINCT * FROM (SELECT b FROM t2))}
124   execsql {SELECT count(*) FROM (SELECT * FROM (SELECT DISTINCT b FROM t2))}
130     FROM (SELECT count(*),b FROM t2 GROUP BY b) AS a,
137     SELECT a.b, a.[count(*)], [max(a)], [count(*)]
138     FROM (SELECT count(*),b FROM t2 GROUP BY b) AS a,
146     FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY b) AS a,
154     FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
169        FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
242     SELECT [count(*)],y FROM (SELECT count(*), y FROM t1 GROUP BY y)
243     ORDER BY [count(*)]
248     SELECT [count(*)],y FROM (SELECT count(*), y FROM t1 GROUP BY y)
577     FROM (SELECT count(*) AS cnt, w AS xyz FROM t1 GROUP BY 2)
582     FROM (SELECT count(*) AS cnt, w AS xyz FROM t1 GROUP BY 2)
587     FROM (SELECT count(*) AS cnt, w AS xyz FROM t1 GROUP BY 2)
593     FROM (SELECT count(*) AS cnt, w AS xyz FROM t1 GROUP BY 2)
601     FROM (SELECT count(*) AS cnt, w AS xyz FROM t1 GROUP BY 2)
611     FROM ( SELECT count(*) AS cnt FROM t1 );