SELECT X, Y, Z
FROM
 (SELECT X, Y, Z 
  FROM SOMETABLE
  ORDER BY X) TEMPVIEW
WHERE ROWNUM <= 100;

Example 1: Batches via ORDER BY and ROWNUM.