In SQL, which clause is used to filter rows from a table?OptionsSORT BYWHEREGROUP BYFILTER

Step 1: Break Down the Problem

The question is asking about SQL clauses used to filter rows from a table. The options provided are: SORT BY, WHERE, GROUP BY, and FILTER.

Step 2: Relevant Concepts

1. WHERE Clause: This clause is specifically designed to filter records according to specified conditions.
2. SORT BY Clause: This clause is used for sorting results based on one or more columns.
3. GROUP BY Clause: This is used to group rows that have the same values in specified columns into summary rows.
4. FILTER Clause: This clause is less common and is typically used in aggregate functions to filter the results but is not primarily meant to filter rows.

Step 3: Analysis and Detail

Among the options given:

• The WHERE clause directly filters records.
• SORT BY organizes the data but does not filter it.
• GROUP BY organizes data into groups.
• FILTER is not primarily used for filtering rows but can be applied within aggregate functions.

Step 4: Verify and Summarize

The most accurate and widely used clause for filtering rows in SQL is the WHERE clause.

Final Answer

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