Limit

Limit every list query (entity,field,fieldbox) throught limitBy(int size)

Select.from(daoPizza)
	.limitBy(5)
	.consumeEach(Printer::printPizza);

Only 5 records will be selected

When you want skip some first entities, use offset:

Select.from(daoPizza)
	.limitBy(5,5)
	.consumeEach(Printer::printPizza);

Only 5 records, from 5 to 10, will be selected.

Use dynamic Limit as well:

Limit dynamicLimit=new Limit();
dynamicLimit.setOffset(16);
dynamicLimit.setLimit(8);
		
Select.from(daoPizza)
	.limitBy(dynamicLimit)
	.consumeEach(Printer::printPizza);