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。