(1) 查询18.20.21岁的学生;
select *
from student
where sage in(18,20,21);
(2) 查询最大的年龄是几岁;
select max(sage)
from student;
(3) 查询学号中至少3个0的学生;
select *
from student
where sno like "%0%0%0%%";
(4) 统计全部学生人数;
select count(sno)
from student;
(1) 查询18.20.21岁的学生;
select *
from student
where sage in(18,20,21);
(2) 查询最大的年龄是几岁;
select max(sage)
from student;
(3) 查询学号中至少3个0的学生;
select *
from student
where sno like "%0%0%0%%";
(4) 统计全部学生人数;
select count(sno)
from student;