sql - MS ACCESS: How can i count distinct value using access query? - Stack Overflow

sql - MS ACCESS: How can i count distinct value using access query? - Stack Overflow

瀏覽:1245
日期:2024-07-09
try select ..., count(distinct Training.Tcode) as ..., ... EDIT - please now look at this... Take the following SQL code. The first select is how SQL server would do this and the second query should be access compliant... declare @t table (eCode int, tcod...看更多