Subject Re: [firebird-support] Does column order in select and group by clause affect the order of result set?
Author Thomas Steinmaurer
> I have select with select and group by clause and the first column
> (data type is integer) in each of them is the same and it is column
> (not aggregated function), so - how wise is to rely, that the result
> set will be ordered by this first column in the ascending order, if I
> will never use order by clause to override this ordering? I tried and
> it works, but I don't know whether such behavior is by design or by
> chance? I have read some posts about Orace - they have some parameters
> that affects this behavior..

It's pretty simple, don't rely on any order in the result set when you
don't use an explicit ORDER BY clause.

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
My blog: