Apologies .. I assumed the random() example was a "created to show the effect" query by the OP. ?Your example was the one using the date function.
-------- Original message -------- From: J Decker <d3c...@gmail.com> Date: 26/08/2015 11:42 (GMT+00:00) To: Graham Holden <SQLite at aldurslair.com>,General Discussion of SQLite Database <sqlite-users at mailinglists.sqlite.org> Subject: Re: [sqlite] order by not working in combination with random() On Wed, Aug 26, 2015 at 2:47 AM, Graham Holden <SQLite at aldurslair.com> wrote: > And while "SELECT random() AS rr ORDER BY rr" is slightly contrived, the > example from J Decker: > contrived? cause I copied it from the original poster's first message? it was used in MySQL as a way to shuffle a deck of cards, and worked there too.
