2021-08-04 WHERE条件查询

SELECT studentno,`studentresult` FROM result

-- 查询考试成绩95-100分之间的
SELECT studentno,`studentresult` FROM result
WHERE studentresult>=95 AND studentresult<=100
-- 除了1000号学生之外的同学的成绩
SELECT studentno,`studentresult` FROM result
WHERE studentno!=1000;