SELECT X, Y, Z 
FROM SOMETABLE
ORDER BY X
LIMIT 100;

Example 2: Batches via LIMIT.