[R] Suggestion for big files [was: Re: A comment about R:]
h.wickham at gmail.com
Fri Jan 6 08:28:27 CET 2006
> Selecting a sample is easy. Yet, I'm not aware of any SQL device for
> easily selecting a _random_ sample of the records of a given table. On
> the other hand, I'm no SQL specialist, others might know better.
There are a number of such devices, which tend to be rather SQL
variant specific. Try googling for select random rows mysql, select
random rows pgsql, etc.
Another possibility is to generate a large table of randomly
distributed ids and then use that (with randomly generated limits) to
select the appropriate number of records.
More information about the R-help