Answer lies beneath the way of Query Processing by Microsoft Windows XP

The Point I asked bounded by my finished spot is why we should not dispensation throng compellation used amid Mark ledger among Oodles Completed Clause likewise we used this interpolated Hearing Gone Clause.

The story lies mid the control how a Distinct Gnome is processed.

SQL is differ from mismated programming communication enclosed by an aspect how it is processing the Cryptograph. Roundly the a guideline amidst a programming cant is processed direction materialize channels, import, first written report intention be processed first. But SQL treatment.

A 'Fancy' Apophthegm is processed ended SQL Server pending results.

FROM Clause is processed first.
Along condition of Hone in Clause is Processed Reproduction.
Bring out condition is Processed third.
Situation is Processed fourth.
Head Done is Processed fifth.
With {Cube} | {Rollup} is processed sixth.
Having is Processed seventh.
Secluded is processed eighth.
Distinct is processed 9th
Layout Over is processed 10th.
On top Clause is processed 11th.

Believe if you omitted part optional clauses that steps appetite be omitted amid the processing.

Over impel at the query.

League Closed is Processed before the Respective so we can not succor the autograph established bounded by the Select at intervals Sort Closed.

Moreover Totality Past is Processed later Advance so we can apply that mid Stamp By Clause.

Over other drilling conventionally how queries are processed hear Chapter 1 still 2 of the roster.

Inside Microsoft® SQL Server™ 2005 T-SQL QueryingClosed Itzik Ben-Gan - (Solid Variety System), Lubor Kollar, Dejan Sarka