Re: How to select a random row from each sub table after "group by"?
Date: Thu, 04 Jun 2009 11:35:03 +0200
> I don't know if I have understood correctly what you ask, anyway here's
> my 2 cents
A better (?) solution with same data and table structure as above:
max(data1) keep (dense_rank first order by rnd), max(data2) keep (dense_rank first order by rnd) from
class, data1, data2, dbms_random.random rnd from x
; Received on Thu Jun 04 2009 - 04:35:03 CDT