Forum Discussion
WINDOW and RAND
yes, as long as your assumption holds true. The usual disclaimer applies - RAND is not truly random.
I'm looking to produce random sample for each partition of A, B and C. I use RAND() to return a random number and then select everything with the random number below a certain value to get a propotion of each partition. This is reliant on the random numbers for each parition being evenly distributed, for example no skew to the upper end or lower ends of RAND(), which produces a number between 0 and 1. Assuming each partition contains many data points, can I use WINDOW and RAND() in the described way to get a evenly distributed set of random numbers for each partition?
Thank you for responding.
yes, as long as your assumption holds true. The usual disclaimer applies - RAND is not truly random.