SELECT * FROM ( SELECT * FROM employee WHERE empstats = 1 AND pernr < 99900000 AND subgrp = 'NE' ORDER BY dbms_random.Value ) WHERE rownum <= 129
select a_id, dbms_random.value() rnd from tableA order by rnd
No comments :
Post a Comment