3. 条件查询
1.where子句后跟条件
2. 运算符
*> 、< 、<= 、>= 、= 、<>*BETWEEN...AND*IN( 集合)*LIKE:模糊查询
* 占位符:
* _:单个任意字符
*%:多个任意字符
*ISNULL*and 或 &&*or 或 ||*not 或 !-- 查询年龄大于20岁SELECT*FROM student WHERE age >20;SELECT*FROM student WHERE age >=20;-- 查询年龄等于20岁SELECT*FROM student WHERE age =20;-- 查询年龄不等于20岁SELECT*FROM student WHERE age !=20;SELECT*FROM student WHERE age <>20;-- 查询年龄大于等于20 小于等于30SELECT*FROM student WHERE age >=20&& age <=30;SELECT*FROM student WHERE age >=20AND age <=30;SELECT*FROM student WHERE age BETWEEN20AND30;-- 查询年龄22岁,18岁,25岁的信息SELECT*FROM student WHERE age =22OR age =18OR age =25SELECT*FROM student WHERE age IN(22,18,25);-- 查询英语成绩为nullSELECT*FROM student WHERE english =NULL;-- 不对的。null值不能使用 = (!=) 判断SELECT*FROM student WHERE english ISNULL;-- 查询英语成绩不为nullSELECT*FROM student WHERE english ISNOTNULL;
-- 查询姓马的有哪些? likeSELECT*FROM student WHERE NAME LIKE'马%';-- 查询姓名第二个字是化的人SELECT*FROM student WHERE NAME LIKE"_化%";-- 查询姓名是3个字的人SELECT*FROM student WHERE NAME LIKE'___';
-- 查询姓名中包含德的人SELECT*FROM student WHERE NAME LIKE'%德%';