orcle_day01

where salary between 100 and 1000;
where salary not between 100 and 1000;

eg:
select id,salary
from s_emp
where id between 4 and 10;
[4,10]
eg:
select id,salary
from s_emp
where salary not between 1000 and 2000;

3,列名 (not) in(41,42,43)某一列的值只能是括号里的数据
eg：where 列名 in(41,10)

select id,salary
from s_emp
where id in (1,2,3,4,5);

工资1250|1000|1200

select id,salary
from s_emp
where salary in(1250,1000,1200);

4,and 且
需要连接多个条件

语法:where 条件一 and 条件二 当条件一和条件二都满足的数据才会被查询出来

eg:工资不在1000-2000之间的员工信息

（编辑：网站开发网_盐城站长网 ）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!