1、distinct
select count(distinct CName) from teble select count(CName) from (select distinct CName from Course) as temp
SELECT DISTINCT text_zhcn FROM dms_menuconfig -- 去重查询表中数据
2、group by
select count(1) from Course group by CName
原文：https://www.cnblogs.com/lu2527/p/10824847.html