Which of the following words is used to restrict the records that are returned from a SELECT query based on a supplied criteria for the values in the records?
A.
LIMIT
B.
FROM
C.
WHERE
D.
IF
Explanation:
The WHERE clause is used to extract only those records that fulfill a specified criterion.Limit is used to limit your query results to those that fall within a specified range. You can use it to show the first X number of results, or to show a range from X – Y results. It is phrased as Limit X, Y and included at the end of your query. X is the starting point (remember the first record is 0) and Y is the duration (how many records to display).