Re: Outputting Selects in Random Order

[Thimble Smith]

At 14:50, 19991005, Hunter Hillegas wrote:
>Is there any way from something like 'SELECT * FROM RECORDS' would output
>the results in a random order, not by insertion order?

Check the mailing list for "random", there's been several discussions on
it.

A select does *not* happen in insertion order by default.  Please do not
depend on that in your programs, because they will certainly break.  You
can not count on any order back from a SELECT unless you specify one with
an ORDER BY clause!

Tim