1--两种查法得出的结果一样 都是统计有多少个不同的老师2 SELECT COUNT( DISTINCT TeacherID) FROM Student3 4SELECT COUNT(*) FROM ( SELECT DISTINCT TeacherID FROM Student) T
来源: