SQL GROUP BY

Table: Subject_Selection

Subject   Semester   Attendee
---------------------------------
ITB001    1          John
ITB001    1          Bob
ITB001    1          Mickey
ITB001    2          Jenny
ITB001    2          James
MKB114    1          John
MKB114    1          Erica

我们想统计每门课程有多少个学生报名，应用如下SQL：

SELECT Subject, Count(*)
FROM Subject_Selection
GROUP BY Subject

得到如下结果：

Subject    Count
------------------------------
ITB001     5
MKB114     2

 这样的话就完成了Subject栏位的去重

 

 

SELECT Subject, Semester, Count(*)
FROM Subject_Selection
GROUP BY Subject, Semester

得到的结果是：

Subject    Semester   Count
------------------------------
ITB001     1          3
ITB001     2          2
MKB114     1          2

这样的话就完成了对多个字段的去重