Which statement describes the purpose of the WHERE clause?

Which statement describes the purpose of the WHERE clause?

• A. It defines the order of the result set
• B. It limits the number of rows returned
• C. It filters rows based on a condition
• D. It aggregates results

Answer: (C)

The purpose of the WHERE clause is to filter rows by a condition. It checks each row and includes it in the result only if the condition is true, letting you retrieve only the records that meet your criteria. For example, selecting records for which department equals 'Sales' returns just those employees. You can combine conditions with AND, OR, and NOT, and use operators like =, >, IN, LIKE, and BETWEEN. The WHERE clause filters input before any grouping or sorting, and it is separate from ordering (ORDER BY), limiting the number of rows (LIMIT/TOP), or aggregating data (GROUP BY with aggregates).

The purpose of the WHERE clause is to filter rows by a condition. It checks each row and includes it in the result only if the condition is true, letting you retrieve only the records that meet your criteria. For example, selecting records for which department equals 'Sales' returns just those employees. You can combine conditions with AND, OR, and NOT, and use operators like =, >, IN, LIKE, and BETWEEN. The WHERE clause filters input before any grouping or sorting, and it is separate from ordering (ORDER BY), limiting the number of rows (LIMIT/TOP), or aggregating data (GROUP BY with aggregates).