] On Behalf Of Jon Westcot
Sent: Monday, November 05, 2012 7:51 PM
To: profoxt...@leafe.com
Subject: Re: Random subset of records.
Hi Alan:
Just wondering if you ever came to a resolution to your question below.
I'm curious to hear how you solved this issue.
Sincerely,
Jon
at a time.
Using a SQL-Select, how would I retrieve a random subset of the records?
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http
included again.
However, due to constraints I can only take a subset of those candidate
records at a time.
Using a SQL-Select, how would I retrieve a random subset of the records?
How about something like:
SELECT TOP n RAND(), other_columns... FROM your_table ORDER BY 1
to get n samples.
dt
-Select, how would I retrieve a random subset of the records?
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list
candidate
records at a time.
Using a SQL-Select, how would I retrieve a random subset of the records?
I must be misunderstanding.why not just use a WHERE ID NOT IN
(SELECT * FROM YOUR_EXCLUSIONS_TABLE)
??
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software
at a time.
Using a SQL-Select, how would I retrieve a random subset of the records?
Why not just flag the ones you do process, then they won't get included
next time.
Peter
Rajan Imports has changed - we are now Whispering
, then flag them
as processed so they do not get included again.
However, due to constraints I can only take a subset of those candidate
records at a time.
Using a SQL-Select, how would I retrieve a random subset of the records?
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
7 matches
Mail list logo