Re: How to select a random row from each sub table after "group by"?
From: steph <stephan0h_at_yahoo.de>
Date: Thu, 4 Jun 2009 01:56:09 -0700 (PDT)
Message-ID: <bc049a24-1aa5-4aa5-983d-72e7c9b91282_at_i6g2000yqj.googlegroups.com>
On 4 Jun., 07:09, Phper <hi.steven..._at_gmail.com> wrote:
> After "group by", the big table is grouped into many sub tables. I
> want to select a random row from each sub table. That's what I want.
> How can I realize/implement it?
Date: Thu, 4 Jun 2009 01:56:09 -0700 (PDT)
Message-ID: <bc049a24-1aa5-4aa5-983d-72e7c9b91282_at_i6g2000yqj.googlegroups.com>
On 4 Jun., 07:09, Phper <hi.steven..._at_gmail.com> wrote:
> After "group by", the big table is grouped into many sub tables. I
> want to select a random row from each sub table. That's what I want.
> How can I realize/implement it?
One quick guess: You could implement a pipeline-function, which reads in the whole table, but only returns one or more random records. Received on Thu Jun 04 2009 - 03:56:09 CDT