分组的时候除重SELECT COUNT(DISTINCT column(s)) FROM table
定义和用法可以一同使用 DISTINCT 和 COUNT 关键词,来计算非重复结果的数目。语法SELECT COUNT(DISTINCT column(s)) FROM table实战语法"Orders"表:CompanyOrderNumberIBM3532W3School2356Apple4698W3School6953例子 1SELECT COUNT(Company) FROM Orders结果:4例子 2SELECT CO