[ale] Organizing data / SQL Question

[cfowler at outpostsentinel.com (Chris Fowler)]

On Wed, 2004-04-28 at 11:24, Jason Etheridge wrote:
> > Group by alarm.alarm_id did it.
> 
> Coolness.  I'm just wary of trusting rows to be spit out in a specific 
> order without an actual ORDER BY clause.  And if I'm using GROUP BY and
> do something like:
> 
> select * from bleh GROUP BY age;
> 
> when the table looks like:
> 
> +-------+------+
> | name  | age  |
> +-------+------+
> | Jason |   28 |
> | Food  |   28 |
> | Posh  |   28 |
> | Apple |   26 |
> +-------+------+
> 
> I don't intuitively know if I'm going to get:
> 
> +-------+------+
> | name  | age  |
> +-------+------+
> | Apple |   26 |
> | Jason |   28 |
> +-------+------+
> 
> or
> 
> +-------+------+
> | name  | age  |
> +-------+------+
> | Apple |   26 |
> | Food  |   28 |
> +-------+------+
> 
> or what.  Is this behavior actually defined in SQL?

I do not know maybe someone else does?
> 
> -- Jason