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/Reference:
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).