I have to randomly pick rows from a table. I am doing this by using the rand() function inside the qualifying row statement. I want the random picks to collectively add up to 100 or close to 100 but cannot be greater than that (Qty field below). Below is an illustration of the input table CID Qty ABC 5 […]
Headline
Tag: google-bigquery
Back To Top