SELECT*FROM student WHERE introduce LIKE '%天%'
SELECT*FROM student WHERE createDate BETWEEN '2024-02-24 00:00:00' and '2024-02-26 10:00:00';
SELECT*FROM student WHERE userName not in ('女娲','蚩尤','伏羲');
3聚合函数
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;