SQL statement processing order

SQL statement processing order

The clauses of the select are processed in the following sequence

• FROM clause
• WHERE clause
• GROUP BY clause
• HAVING clause
• SELECT clause
• ORDER BY clause
• TOP clause