> 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. Hadley ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
