Chapter 8, Problem 1RQ

Explanation of Solution

“WHERE” clause:

• The “WHERE” clause is used to limit the number of rows.
• The “WHERE” clause is used for checking a condition while fetching the data from a single table or by joining with multiple tables.
• When the given condition is satisfied, the specific value is returned from database.
• By using “WHERE” clause we have to filter specific records from table.
• “WHERE” clause is used in “SELECT”, “UPDATE” and “DELETE” statements.

Therefore, the “WHERE” clause is used to limit the number of rows returned.