> To further emphasize this point: A table has no order by itself,
That's not entirely true ;-) Records are stored in some kind of physical
order, some DBMSses implement clustered keys, meaning that the
records are stored ascending order on disk.
>and you should make no assumptions about the order of rows you will get
>back in a select statement, unless you use an ORDER BY clause.
This is correct in that a -result set- does not have an "order" defined
unless you specify an ORDER BY clause.
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum: