SELECT * FROM (SELECT * FROM t_sys_area t WHERE t.area_level='2' ORDER BY dbms_random.random) WHERE ROWNUM<=10ORDER BY area_id;