17,377
社区成员
发帖
与我相关
我的任务
分享
select dept.dno,dept.dname,employee.sex,count(*)as count_eno from employee,dept
where dept.dno=employee.dno group by employee.sex,dept.dno
如果要这样写就应该是:
select dept.dno,dept.dname,employee.sex,count(*)as count_eno from employee,dept
where dept.dno=employee.dno group by dept.dno,dept.dname,employee.sex