Which SQL clause identifies the table to query?

Which SQL clause identifies the table to query?

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

Answer: (B)

In SQL, the clause that specifies where the data comes from is the FROM clause. It tells the database which table (or tables) to query for the results. For example, in a statement like SELECT name, age FROM Employees, the table being queried is Employees. The FROM clause is the anchor that identifies the data source. The other parts have different jobs: SELECT decides which columns to return, WHERE filters which rows are included, and ORDER BY sorts the final results. So the FROM clause is the one that identifies the table to query.

In SQL, the clause that specifies where the data comes from is the FROM clause. It tells the database which table (or tables) to query for the results. For example, in a statement like SELECT name, age FROM Employees, the table being queried is Employees. The FROM clause is the anchor that identifies the data source.

The other parts have different jobs: SELECT decides which columns to return, WHERE filters which rows are included, and ORDER BY sorts the final results. So the FROM clause is the one that identifies the table to query.