?? 19.查詢employees表中各部門的人數.sql
字號:
select departments.depname as '部門',count(*) as '人數'
from departments inner join employees on departments.depid= employees.department
group by departments.depname?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -