ms sql count distinct的相關文章
ms sql count distinct的相關公司資訊
ms sql count distinct的相關商品

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 ......看更多