SELECT * FROM student WHERE introduce LIKE '%,%';
SELECT * from student WHERE sex is null;
SELECT * FROM student WHERe id BETWEEN 10 AND 20;
SELECT * FROM student WHERE age BETWEEN 150 and 200;
SELECT * from student WHERE
createDate BETWEEN '2024-02-21 10:10:10' and '2024-02-28 10:10:10';
SELECT * from student WHERE userName not IN ('盘古','神农','蚩尤');
SELECT * from student WHERE userName IN ('盘古','神农','蚩尤');
例如:in
聚合函数
#聚合函数会涉及到5个单词:数量count()、最大max()、最小()、平均数avg()、求和sum()
SELECT count(*) '数据总条数' from student WHERE pwd is not null;
SELECT max(age) '年龄最大' from student;
SELECT min(age) '年龄最小' from student;
SELECT avg(age) '平均年龄' from student;
SELECT SUM(age) '年龄总和' from student;
#使用年龄综合计算一下平均数
SELECT sum(age)/(SELECT count(*)'数据总条数' from student) '平均年龄' from student;