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

瀏覽:695
日期:2024-07-09
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 ......看更多