mysql 分组后查询总行数,不使用子查询

SELECT count(DISTINCT SCAC) FROM biao WHERE BASE_CODE = 'cnsha'  
原文地址:https://www.cnblogs.com/angdh/p/11637553.html