sql查询员工信息排除领导的_mysql基础级《简单查询》60分钟搞定

初学者，推荐大家使用----emp(雇员信息表)和dept(部门表)，这两张表的字段及数据内容都设计的比较经典。来吧！先跟着我的操作，导入我提供的数据库脚本。

导入两张表sql脚本到数据库

create database testdb;

use testdb;

drop table if exists `emp`;

create table `emp` (

`empno` int(4) default null comment '雇员编号',

`ename` varchar(10) default null comment '雇员名称',

`job` varchar(9) default null comment '雇员工作',

`mgr` int(4) default null comment '上级领导编号',

`hiredate` date default null comment '雇佣日期',

`sal` decimal(7,2) default null comment '雇员工资',

`comm` decimal(7,2) default null comment '雇员奖金',

`deptno` int(2) default null comment '部门编号'

) engine=innodb default charset=utf8;

insert into `emp`(`empno`,`ename`,`job`,`mgr`,`hiredate`,`sal`,`comm`,`deptno`) values (7369,'smith','clerk',7902,null,'800.00',null,20),(7499,'allen','salesman',7698,null,'1600.00','300.00',30),(7521,'ward','salesman',7698,null,'1250.00','500.00',30),(7566,'jones','manager',7839,null,'2975.00',null,20),(7654,'martin','salesman',7698,null,'1250.00','1400.00',30),(7698,'blake','manager',7839,null,'2850.00',null,30),(7782,'clark','manager',7839,null,'2450.00',null,10),(7788,'scott','analyst',7566,null,'3000.00',null,20),(7839,'king','president',null,null,'5000.00',null,10),(7844,'turner','salesman',7698,null,'1500.00','0.00'