ms sql count distinct的相關文章
ms sql count distinct的相關商品
![sql - MS ACCESS count/sum number of rows, with no duplicates - Stack Overflow](https://www.iarticlesnet.com/pub/img/site/s_44.jpeg)
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 ......看更多