Re: [sqlite] How not to let random be calculated again and again and

2017-11-06 11:11 GMT+01:00 Cecil Westerhof : > 2017-11-06 10:39 GMT+01:00 Keith Medcalf : > >> >> The easiest way is likely to make the query so that it cannot be >> flattened by adding an ORDER BY (that does not reference the column >> containing the non-deterministic function by name -- ie, use

Re: [sqlite] How not to let random be calculated again and again and

m not sure in which programming language the real version will be implemented, but it will probably use a version near that one. For example my Java uses 3.20.0. > >-Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behal

Re: [sqlite] How not to let random be calculated again and again and

r, 2017 01:16 >To: SQLite mailing list >Subject: [sqlite] How not to let random be calculated again and again >and > >I have a query that I use to randomly select a set of records, but an >older >one should have a higher change and a never used record is selected >before >a used

[sqlite] How not to let random be calculated again and again and

I have a query that I use to randomly select a set of records, but an older one should have a higher change and a never used record is selected before a used record. For this I use a query that looks a bit like this: SELECT "Last Used" , Randomiser , Randomiser , Rand