emp为员工表,表结构如下:create table emp(empid int, empname varchar(100), deptid int);
emp表数据插入如下:
insert into emp(empid, empname, deptid) values(11,'张三', 1001);
insert into emp(empid, empname, deptid) values(12,'李嘉', 1001);
insert into emp(empid, empname, deptid) values(13,'王五', 1002);
insert into emp(empid, empname, deptid) values(14,'赵六', 1003);
insert into emp(empid, empname, deptid) values(15,'李学光', 1005);
insert into emp(empid, empname, deptid) values(16,'陈子李', 1005);
insert into emp(empid, empname, deptid) values(17,'赵乾', 1005);
dept为部门表,表结构如下:
create table dept(deptid int, deptname varchar(100));
dept表数据插入如下:
insert into dept(deptid, deptname) values(1001, '人力资源部');
insert into dept(deptid, deptname) values(1002, '财务部');
insert into dept(deptid, deptname) values(1003, '公关部');
insert into dept(deptid, deptname) values(1004, '销售部');
下列sql的查询结果正确的是:
select count(*) from emp full outer join dept on emp.deptid=dept.deptid;