Re: SQL ORDER BY

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 29 Aug 2001 12:29:21 -0500
Message-ID: <uzo8ifw5p.fsf@verizon.net>

On Wed, 29 Aug 2001, jdboyer_at_icomproductions.ca wrote:

> I know this is a dumb question but is there a way to Order by
> RANDOM? I need my query to order its results randomly every
> time it is run.

There are no stupid questions, just stupid people who ask questions :-) (Just a quote, and meant only as a complete joke) I'm sure I could come up with reasons for the request.

> If any can help, please point me in the right direction
> Jeff

Go here
http://asktom.oracle.com/pls/ask/f?p=4950:7:53637::NO::: and search random. I think the article "Randolmy select the records from a table" will have what you need.

-- 
Galen Boyer
It seems to me, I remember every single thing I know.

Received on Wed Aug 29 2001 - 12:29:21 CDT