Select Query Default Order
638331May 8 2008 — edited May 9 2008Hi,
I have a question on the order of result return by select query if we do not specify order by clause.
Is there a way from system level we can force the order into sequentail order?
i.e. Table EMP ( Col1 Number, Col2 Name);
select * from EMP returns the result in random order of IDs. If I want it to return in Order by ID asc without changing my code ( SQL Query ), will it be possible to force the query at the database system level.