> 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
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/