Which of the following words is used to restrict the records that are returned from a SELECT SQL query based on a supplied criteria for the values in the records?

A. CASE
B. FROM
C. WHERE
D. IF

题解

SELECT 叙述可以加上「WHERE」关键字来设置查找的条件,用法如下:

SELECT * FROM tablename WHERE column1 = value1 AND column2 < value2 OR column3 > value3

所以答案是选项 C。