|Re: [firebird-support] Does column order in select and group by clause affect the order of result set?
> I have select with select and group by clause and the first columnIt's pretty simple, don't rely on any order in the result set when you
> (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..
don't use an explicit ORDER BY clause.
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and