where子句之逻辑运算符

-- ======================== WHERE ==============================
SELECT studentno,studentresult FROM result


-- 查询成绩在95-100之间的数据
SELECT studentno,studentresult FROM result 
WHERE studentresult>=95 AND studentresult<=100

-- AND &&
SELECT studentno,studentresult FROM result 
WHERE studentresult>=95 && studentresult<=100

-- 模糊查询(区间)
SELECT studentno,studentresult FROM result 
WHERE studentresult BETWEEN 95 AND 100

-- 除了1000号学生之外的学生成绩
SELECT studentno,studentresult FROM result
WHERE studentresult != 1000

-- != NOT
SELECT studentno,studentresult FROM result
WHERE NOT studentresult = 1000