Subject Does column order in select and group by clause affect the order of result set?
Author vincent_kwinsey
Hi,

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

Vincent.