sql - MS ACCESS count/sum number of rows, with no duplicates - Stack Overflow

sql - MS ACCESS count/sum number of rows, with no duplicates - Stack Overflow

瀏覽:448
日期:2025-04-28
This would work in SQL, I think it should also in Access: SELECT COUNT(DISTINCT CustomerID) FROM TheTable Edit: Per Jeff in comments, Access doesn't support the above syntax. This should work for sure though: SELECT COUNT(*) FROM ( SELECT ......看更多