--一个知识点
--where查询条件
--1、where 25 = age 和 where age = 25是合法且相同的语句
--2、比较运算符:= < <= > >= != <> ^=
-- between...and...(包含边界),in(list),like(_),is null
-- not between...and...,not in,not like,is not null
--3、逻辑运算符:not and or
--in后有无空格都可以
--判断某一列是否为空: is null;不能使用=
--优先级: not>and>or
--例一
select * from sc t where t.grade = 68;
select * from sc t where 68 = t.grade;
--例二
select * from sc t where t.grade > 80;
select * from sc t where t.grade between 60 and 80;
select * from sc t where t.sno like '__1%';
select * from sc t where t.sno in ('9513101','');
--where查询条件
--1、where 25 = age 和 where age = 25是合法且相同的语句
--2、比较运算符:= < <= > >= != <> ^=
-- between...and...(包含边界),in(list),like(_),is null
-- not between...and...,not in,not like,is not null
--3、逻辑运算符:not and or
--in后有无空格都可以
--判断某一列是否为空: is null;不能使用=
--优先级: not>and>or
--例一
select * from sc t where t.grade = 68;
select * from sc t where 68 = t.grade;
--例二
select * from sc t where t.grade > 80;
select * from sc t where t.grade between 60 and 80;
select * from sc t where t.sno like '__1%';
select * from sc t where t.sno in ('9513101','');