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。
