SELECT count(DISTINCT SCAC) FROM biao WHERE BASE_CODE = ‘cnsha‘
mysql 分组后查询总行数,不使用子查询
原文：https://www.cnblogs.com/angdh/p/11637553.html
