Yes it is a myth. The records will come back in the same order IF there have been not inserts and deletes. Depends on the database product to.
> My boss says that if you do a select statement against a table the > result set always comes back in the same order. I say that this is a > myth and that the result is random, except when some ordering is > specified in the SQL statement. > > Who is right? Is this behavior specified by ANSI or ISO? > > Best Regards, > Boyd E. Hemphill > [EMAIL PROTECTED] > Triand, Inc. > www.triand.com > O: (512) 248-2287 > M: (713) 252-4688 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
