summaryrefslogtreecommitdiff
path: root/mysql-test/r/count_distinct.result
blob: 97d7b57f2497a0ef02c47bbbf6244e35f2a24b09 (plain)
1
2
3
4
5
6
7
8
9
10
11
isbn	city	libname	a
007	Berkeley	Berkeley Public1	1
007	Berkeley	Berkeley Public2	1
000	New York	New York Public Libra	6
001	New York	NYC Lib	1
006	San Fran	San Fransisco Public	1
isbn	city	libname	a
007	Berkeley	Berkeley Public1	2
000	New York	New York Public Libra	2
f1	count(distinct t2.f2)	count(distinct 1,NULL)
1	0	0