kaspencer (8/14/2013)
I have worked with SQL Server on and off for many years, but I don't think I recall ever seeing "ORDER BY [number]" as it appears in this question.Could some kindly person explain this to me, because a clear explanation seems to be difficult to locate in the documentation, and in searches. This little issue was why I failed this question!
Many thanks
Kenneth Spencer
Hi kenneth,
In Order By we can specify integer representing the position of the column in the select list. The result set will be sorted based on the column. For further details pls refer
http://technet.microsoft.com/en-us/library/ms188385.aspx
Also FYI, Order By has no effect in this question, without sorting also you will get the same result, Its matter of Where clause.
I hope you are aware of Where clause will be applied before Order By.
--
Dineshbabu
Desire to learn new things..