1、distinct
select count(distinct CName) from Course
select count(CName) from (select distinct CName from Course) as temp
2、group by
select count(1) from Course group by CName
3、数据库内随机抽取几条数据
from sqlalchemy.sql.expression import func
(变量) = (模型名).query.order_by(func.random()).limit(随机几条).all()