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

  • October 14, 2008 at 12:59 am

    #884428

    Without the ORDER BY clause, you can not predict the order of rows.

    NULL, 1 and 1, NULL are both possible.

    In the future release of sqlserver or in another DBMS, the order may be different.