Sql执行顺序[关闭]

Question

I am confusing with simple query:

SELECT * FROM table_name WHERE name = 'stack';

My question is this which part first execute:

SELECT * FROM table_name

OR

WHERE name = 'stack'

First select all record from table then filter with WHERE condition or first filter records then SELECT?

For more details about question please see this link:

WHERE condition issue in SQL

Thanks

Answer 1

The following steps show the logical processing order, or binding order, for a SELECT statement. This order determines when the objects defined in one step are made available to the clauses in subsequent steps. For example, if the query processor can bind to (access) the tables or views defined in the FROM clause, these objects and their columns are made available to all subsequent steps. Conversely, because the SELECT clause is step 8, any column aliases or derived columns defined in that clause cannot be referenced by preceding clauses. However, they can be referenced by subsequent clauses such as the ORDER BY clause. Note that the actual physical execution of the statement is determined by the query processor and the order may vary from this list.

    FROM
    ON
    JOIN
    WHERE
    GROUP BY
    WITH CUBE or WITH ROLLUP
    HAVING
    SELECT
    DISTINCT
    ORDER BY
    TOP