关键词:WHERE
需求:从students表中,查找成绩为90的学生
代码:
SELECT class_id,score
FROM students
WHERE score=90;
如果这个时候,配合使用ORDER BY呢?
注意需要先用ORDER BY再用WHERE
需求:找出成绩小于90的学生
代码:
SELECT name,score
FROM students
WHERE score<90
ORDER BY score;
需求:查询成绩在90到100之间的学生
代码:
SELECT name,score
FROM students
WHERE score BETWEEN 90 AND 100
ORDER BY score;
特别地:
如果我们希望查询所有为null的值
代码:
SELECT name,score
FROM students
WHERE score IS NULL
ORDER BY score;