SELECT COUNT distinct
SELECT COUNT distinct
(OP)
SELECT CASSA.GIORNO, Count(CASSA.SCONTRINO) AS CONTASCONTRINO
FROM CASSA
WHERE CASSA.ANNULL IS NULL AND CASSA.ANNO='2021' AND CASSA.MESE='8'
GROUP BY CASSA.GIORNO
but i need to count distinct SCONTRINO
In my case the day 01/08/2021 have 11 SCONTRINO
FROM CASSA
WHERE CASSA.ANNULL IS NULL AND CASSA.ANNO='2021' AND CASSA.MESE='8'
GROUP BY CASSA.GIORNO
but i need to count distinct SCONTRINO
In my case the day 01/08/2021 have 11 SCONTRINO
RE: SELECT COUNT distinct
CODE
If that doesn't work, you might try
CODE
RE: SELECT COUNT distinct
i'm on Access
RE: SELECT COUNT distinct
But since it should be a simple copy/paste for you, it would be better if you tested it, no?
RE: SELECT COUNT distinct
This works on Oracle, but Access may have different results.
RE: SELECT COUNT distinct