Lines Matching refs:count
27 SELECT count(distinct a),
28 count(distinct b),
29 count(distinct c),
30 count(all a) FROM t1;
35 SELECT b, count(distinct c) FROM t1 GROUP BY b
43 SELECT count(*), count(distinct a), count(distinct b) FROM t1
48 SELECT a, count(distinct c) FROM t1 GROUP BY a ORDER BY a
54 SELECT count(distinct) FROM t1;
89 1 0 "SELECT count(DISTINCT a) FROM t1" 5
90 2 0 "SELECT count(DISTINCT b) FROM t1" 3
91 3 1 "SELECT count(DISTINCT c) FROM t1" 4
92 4 0 "SELECT count(DISTINCT c) FROM t1 WHERE b=3" 3
93 5 0 "SELECT count(DISTINCT rowid) FROM t1" 10
94 6 0 "SELECT count(DISTINCT a) FROM t1, t2" 5
95 7 0 "SELECT count(DISTINCT a) FROM t2, t1" 5
96 8 1 "SELECT count(DISTINCT a+b) FROM t1, t2, t2, t2" 6
97 9 0 "SELECT count(DISTINCT c) FROM t1 WHERE c=2" 1
98 10 1 "SELECT count(DISTINCT t1.rowid) FROM t1, t2" 10
110 SELECT a, count(DISTINCT b) FROM t1 GROUP BY a;
154 1 0 "SELECT count(DISTINCT c) FROM t1 GROUP BY b" {2 3 0 1}
155 2 1 "SELECT count(DISTINCT a) FROM t1 GROUP BY b" {2 3 0 1}
156 3 1 "SELECT count(DISTINCT a) FROM t1 GROUP BY b+c" {0 1 1 1 1}
158 4 0 "SELECT count(DISTINCT f) FROM t2 GROUP BY d, e" {1 2 2 3}
159 5 1 "SELECT count(DISTINCT f) FROM t2 GROUP BY d" {2 3}
160 6 0 "SELECT count(DISTINCT f) FROM t2 WHERE d IS 1 GROUP BY e" {1 2 2}
174 1 1 "SELECT count(*) FROM t3" 2
175 2 0 "SELECT count(*) FROM t1" 10
176 2 1 "SELECT count(DISTINCT a) FROM t1, t3" 4
177 3 1 "SELECT count(DISTINCT a) FROM t1 LEFT JOIN t3" 4
178 4 1 "SELECT count(DISTINCT a) FROM t1 LEFT JOIN t3 WHERE t3.x=1" 4
179 5 1 "SELECT count(DISTINCT a) FROM t1 LEFT JOIN t3 WHERE t3.x=0" 0
180 6 1 "SELECT count(DISTINCT a) FROM t1 LEFT JOIN t3 ON (t3.x=0)" 4
181 7 1 "SELECT count(DISTINCT x) FROM t1 LEFT JOIN t3" 2
182 8 1 "SELECT count(DISTINCT x) FROM t1 LEFT JOIN t3 WHERE t3.x=1" 1
183 9 1 "SELECT count(DISTINCT x) FROM t1 LEFT JOIN t3 WHERE t3.x=0" 0
184 10 1 "SELECT count(DISTINCT x) FROM t1 LEFT JOIN t3 ON (t3.x=0)" 0
207 SELECT count(DISTINCT c) FROM t1 LEFT JOIN t2;