1. Trace
  2. SELECT binding order

tsql internals development

SELECT binding order

From http://msdn.microsoft.com/en-GB/library/ms189499.aspx.

SELECT statement clauses are bound in this order:

  1. FROM
  2. ON
  3. JOIN
  4. WHERE
  5. GROUP BY
  6. WITH CUBE/WITH ROLLUP
  7. HAVING
  8. SELECT
  9. DISTINCT
  10. ORDER BY
  11. TOP
tsql, internals, development
Sidebar

Find me

  • Email
  • LinkedIn
  • Bluesky
  • GitHub
  • RSS feed

Find something else

Recent posts

  • 04-Apr-2025 – com.microsoft.cdm for Synapse Spark v3.4
  • 28-Mar-2025 – Deploy TMDL semantic models to Power BI
  • 03-Mar-2025 – Unreliable logging in data factory pipelines
  • 10-Sep-2024 – Two-aggregate pivot
  • 13-Aug-2024 – DevOps for SQL databases

More...

Top tags

adf adftesting admin azure blog catalog cicd configuration crib csharp dataops development devex devops disk dokuwiki dos dynamic etl excel extended_events fabric functions git google_analytics graphviz housekeeping linked_servers linux metadata php powerbi powershell running setup spark sprockit sprockitviz sql sql_server ssis ssms ssrs synapse tempdb testing tmsl tsql tsqltuesday windows
I use cookies on my website to help me improve the site and your experience here.
Policy