Which clause is used to select the table in a SELECT query?

In a SQL SELECT query, the clause that specifies the table from which to retrieve data is the FROM clause. This clause is essential as it identifies the source of the data being queried. When formulating a SELECT statement, the FROM clause can contain one or more table names, allowing the user to pull information from those specified tables, which serves as the foundation for any subsequent operations, such as filtering or sorting the data.

The other clauses mentioned serve distinct purposes within the SQL query structure. The WHERE clause is used to filter the results based on specific conditions, the ORDER BY clause determines the sequence in which the results should be returned, and the LIMIT clause restricts the number of rows returned by the query. Each plays its own role within a SELECT statement, but none serve to specify the source table as effectively as the FROM clause does.