Which SQL clause is used to filter results based on a condition?

The SQL clause used to filter results based on a specific condition is the WHERE clause. This clause is essential in SQL queries because it allows you to specify conditions that records must meet to be included in the result set.

For example, if you want to retrieve all customer records where the city is 'New York,' the WHERE clause enables you to filter out records that do not match this criterion, returning only those that satisfy the condition. This is fundamental in creating precise queries that target specific data within a database.

Other clauses mentioned serve different purposes. The GROUP BY clause is utilized to group rows that have the same values in specified columns into summary rows, often in conjunction with aggregate functions. The HAVING clause is used to filter groups created by the GROUP BY clause based on a specified condition. The FROM clause specifies the tables from which to retrieve data, but it does not provide any filtering capabilities.