2020-07-15

数据库类型查询命令
查询工资大于1w元的人员信息
select * from employees where salary>10000
查询部门编号不为100的员工和部门
select id,department from employees where department!=100(<>)
查询工资大于1w小于2w的员工id和工资和部门
select id,salary,department from employees
where salary>10000 and salary<20000

select * from employees where
not(salary<10000 and salary>20000) or department!=100
第三章
like
between and
is null
in
select * from employees where
last_name like ‘%a%’ 注意单引号和百分号是通配符
%代表任意多和零个字符
select lastname ,salary from employees where
lastname like ‘__a_d%’；

代表单个字符，\代表转义，则_代表查找字符
也可以写成’_$_a_d%’ escape $ 指定$为转义符，$可以改为任意字符

select * from employees where
id between 100 and 200;
包括100和200，但是100与200不能调换位置

select * from employees where
job in (‘it’,‘AD’,‘Ae’) ;
注意不支持通配符，数据类型必须一致