• 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