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
Order by [some number], this number indicates the order of the column in the Select clause.
Hope that would help you.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant