#限定条件,使用Where子句
SELECT * FROM student WHERE sage >= 23;
SELECT * FROM student WHERE sage between 23 AND 26;
SELECT * FROM studentinfo WHERE sgraduate IN (‘交大’,‘电大’);
SELECT * FROM grade_copy WHERE sgrade IS NULL;
SELECT * FROM grade_copy WHERE sgrade = NULL; # 注意与上面的对比
#、BETWEEN … and …在什么区间内,等于与 age >=50 and age <=70
select * from student where age BETWEEN 50 and 70
#2 集合操作
匹配多个值
IN 运算符用于 WHERE 表达式中,以列表项的形式支持多个选择,语法如下:
WHERE column IN (value1,value2,…)
WHERE column NOT IN (value1,value2,…)
当 IN 前面加上 NOT 运算符时,表示与 IN 相反的意思,即不在这些列表项内选择。
in:列名和多个值进行匹配 ,匹配到相同值所在的行显示出来
– not in :用列名和多个值进行匹配,匹配到不相同的值所在的行显示出来
select 列a…from 表 where 条件1=值1 or 条件1=值2 or 条件1 = 值3
IN:
select 例a…from 表 where 条件 IN(值1,值2,值3);
select name from student where id IN (1,2,3);
NOT IN:
select 列a…from 表 where 条件 not inz(值1,值2,值3)
select name from student where id not in (1,2,3)