In SQL, which clause is used to filter rows from a table?OptionsGROUP BYFILTERSORT BYWHERE

Answer

The correct clause used to filter rows from a table in SQL is the WHERE clause.

Explanation

The WHERE clause allows you to specify conditions that must be met for rows to be included in the result of a query. It is essential for retrieving specific data based on given criteria.

Here’s how it functions in a basic example:

SELECT *
FROM Employees
WHERE Department = 'Sales';

In this example, the query retrieves all records from the "Employees" table where the "Department" equals 'Sales'.

While the other options listed (GROUP BY, SORT BY) are used for different purposes—GROUP BY is used for aggregating data, and SORT BY (often referred to as ORDER BY) is used to sort the results—the WHERE clause specifically filters the data based on specified conditions.