Which SQL clause is used to specify the table from which to retrieve data?

• A. WHERE
• B. FROM
• C. ORDER BY
• D. GROUP BY

Answer: (B)

The correct answer is the clause that directly indicates the source of the data in an SQL query. The FROM clause is essential in any SELECT statement, as it specifies the table or tables from which the data is to be retrieved. When you write a query, you need to inform the database server where to look for the information, and the FROM clause serves this purpose by defining the dataset's origin.

Specifying the source table is a fundamental step in querying since it allows the database engine to locate and extract the desired information efficiently. Without this clause, the SQL statement would not know where to fetch the data, making it impossible to retrieve or manipulate the information as intended.

The other clauses, while important in different contexts, do not serve this specific function of pinpointing the source table. The WHERE clause is used to filter records based on specific conditions, the ORDER BY clause sorts the results in a specified order, and the GROUP BY clause organizes records that have the same values in specified columns into summary rows. These clauses contribute to refining or organizing the final result set but do not indicate the table from which the data is being selected.