Re: Picking a random row

"Dave S." <daves_at_nospam.com> wrote:

> Then you could loop through this kind of select statement until you have
> selected enough rows?
>
> Would this not suffice?

Oh, god, no. The table has 600,000 rows. I would work, sure, but it would be hideously inefficient.

-- 
Roy Smith <roy_at_popmail.med.nyu.edu>
New York University School of Medicine
550 First Avenue, New York, NY  10016