List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:August 18 2009 7:31pm
Subject:Re: Query Question
View as plain text  

> 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.

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum: 

Query QuestionBill Arbuckle18 Aug
  • Re: Query QuestionWalter Heck - OlinData.com18 Aug
    • RE: Query QuestionGavin Towey18 Aug
  • Re: Query QuestionMartijn Tonies18 Aug
    • Re: Query QuestionJohnny Withers18 Aug
  • Re: Query QuestionMartijn Tonies18 Aug