I have code that works well to pick X number of random rows from one Group of interest, like Group A... But what if I wanted to get say mutiple random records
from more than one Group ?
Say I wanted to get 250,000 from Group A, 100,000 from Group B, and maybe 50,000 from Group C, how does one do something like that ?
I am on latest version of 11G 64-bit.
SELECT * FROM
(
SELECT customer_id, SYS.DBMS_RANDOM.RANDOM
FROM Table
WHERE REC_TYPE in ('Group A')
ORDER BY 2
)
WHERE rownum <= 250000;