Good evening, I have these expressions: 1: SELECT did, date, COUNT(*) AS zero_entries FROM sync_gateway LET date = SUBSTR(t, 0, 10) WHERE type='bcn_scan' AND date BETWEEN '2016-11-01' AND '2016-12-15' AND ARRAY_LENGTH(bcn)==0 GROUP BY did, date ORDER BY did ASC, date ASC; and 2: SELECT did, date…

Yes - indeed "nulld_entries" : COUNT(*) - COUNT(NULLIF(ARRAY_LENGTH(bcn), 0)) is the same; but slower than "nulld_entries" : COUNT(CASE WHEN ARRAY_LENGTH(bcn)==0 THEN 1 ELSE NULL END) What about [image] sntentos: I’d like to “merge” did value (d46cb7bd3c6001e00ba3fd43eca39428) with the a…

COUNT condition

SQL++

sntentos February 20, 2017, 4:21pm 19

You are right, I got sidetracked:

Topic		Replies	Views
COUNT condition: INDEX Speed-up improvements SQL++ n1ql	34	3621	February 28, 2017
COUNT Condition: Data Format Discussion SQL++ n1ql	7	2042	February 21, 2017
AS expressions are not "caught" by the GROUP BY enforcement SQL++ n1ql	9	1487	February 16, 2017
Count basic , error in group SQL++ n1ql	3	331	April 25, 2024
When I use ">=" operation, consistency is not valid SQL++ n1ql	4	1885	March 11, 2016

COUNT condition

Related topics