List:General Discussion« Previous MessageNext Message »
From:Bob Kline Date:October 5 1999 9:29pm
Subject:Re: Outputting Selects in Random Order
View as plain text  
On Tue, 5 Oct 1999, 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?
> 

SQL does not guarantee anything about the order of retrieval of rows in
the absence of an ORDER BY ... clause.

-- 
Bob Kline
mailto:bkline@stripped
http://www.rksystems.com

Thread
A question about indexesMoz5 Oct
  • Re: A question about indexesBob Kline5 Oct
    • Outputting Selects in Random OrderHunter Hillegas5 Oct
      • Re: Outputting Selects in Random OrderThimble Smith6 Oct
      • Re: Outputting Selects in Random OrderBob Kline6 Oct
        • Re: Outputting Selects in Random OrderScott Hess6 Oct
          • Re: Outputting Selects in Random OrderThimble Smith6 Oct
          • Re: Outputting Selects in Random OrderBob Kline6 Oct
            • Re: Outputting Selects in Random OrderHunter Hillegas6 Oct
              • Re: Outputting Selects in Random OrderBob Kline6 Oct
                • Re: Outputting Selects in Random OrderMartin Ramsch7 Oct
    • Re: Outputting Selects in Random OrderHunter Hillegas6 Oct
Re: A question about indexesMark Papadakis5 Oct
  • Re: A question about indexesBob Kline6 Oct