Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SELECT COUNT distinct
- Thread starter sal21
- Start date
Have you tried:
If that doesn't work, you might try
Code:
SELECT CASSA.GIORNO, Count(DISTINCT CASSA.SCONTRINO) AS CONTASCONTRINO
FROM CASSA
WHERE CASSA.ANNULL IS NULL AND CASSA.ANNO='2021' AND CASSA.MESE='8'
GROUP BY CASSA.GIORNOIf that doesn't work, you might try
Code:
SELECT giorno, count(scontrino)
FROM (SELECT DISTINCT giorno, scontrino
FROM cassa
WHERE ANNULL IS NULL AND ANNO='2021' AND MESE='8') v;- Thread starter
- #3
- Thread starter
- #6
- Status
Similar threads
