Which SQL clause would you use to specify the data source table?

Which SQL clause would you use to specify the data source table?

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

Answer: (D)

The main idea is to identify the data source for a query. In a SELECT statement you choose what to return with SELECT, but you tell the database which table to read data from with the FROM clause. The FROM clause names the table (or tables) that hold the data you want to query. For example, SELECT name, age FROM Students; here the data source is the Students table, indicated by the FROM clause. The other parts of a query have different roles: WHERE filters which rows are included, and ORDER BY determines how the results are sorted. But none of those designate the source table.

The main idea is to identify the data source for a query. In a SELECT statement you choose what to return with SELECT, but you tell the database which table to read data from with the FROM clause. The FROM clause names the table (or tables) that hold the data you want to query. For example, SELECT name, age FROM Students; here the data source is the Students table, indicated by the FROM clause. The other parts of a query have different roles: WHERE filters which rows are included, and ORDER BY determines how the results are sorted. But none of those designate the source table.