Home Forums Article Discussions Article Discussions by Author Discuss content posted by Arup Chakraborty Predict output RE: Predict output

  • October 14, 2008 at 2:26 am

    #884464

    GilaMonster (10/14/2008)

    Hence there's an implicit Order by 1 ASC on the statement.

    Also the DISTINCT clause and the GROUP BY perform an implicit ORDER BY for all cols, but "IMPLICIT" is not the rule nor is written in the BOL.