使ç¨GROUP BYåç»ã
å设表çä¿¡æ¯ä¸ºï¼Employeeï¼CompNameï¼DeptNameï¼EmpNameï¼
--å建æ°æ®è¡¨
CREATE TABLE Employee
(
CompName VARCHAR(20), --åå
¬å¸å称
DeptName VARCHAR(20), --é¨é¨å称
EmpName VARCHAR(20) --åå·¥å§å
)
--æå
¥æµè¯æ°æ®
INSERT INTO Employee VALUES('å京å
¬å¸', '人äºé¨', 'å¼ ')
INSERT INTO Employee VALUES('å京å
¬å¸', 'è´¢å¡é¨', 'èµµ')
INSERT INTO Employee VALUES('å京å
¬å¸', '人äºé¨', 'å')
INSERT INTO Employee VALUES('ä¸æµ·å
¬å¸', '人äºé¨', 'ç')
INSERT INTO Employee VALUES('ä¸æµ·å
¬å¸', 'è´¢å¡é¨', 'æ')
--SQLæ¥è¯¢
SELECT CompName, DeptName, Number = COUNT(*)
FROM Employee
GROUP BY CompName, DeptName
æµè¯ç»æï¼
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0bd162d9f2d3572cca70ec038d13632763d0c35b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)