MySQL——group by字句

group by字句用于根據(jù)字段進(jìn)行分組

例如：

group by 對(duì)符合where條件的數(shù)據(jù)進(jìn)行分組

SELECT 專(zhuān)業(yè)名,COUNT(*) AS '學(xué)生數(shù)'

   FROM XS

   where 性別=1

   GROUP BY 專(zhuān)業(yè)名;