Limit

Limit query throught limitBy(int size)

Select.from(db,tabPizza)
	.limitBy(5)
	.result();

Only 5 records will be selected

To skip, use offset:

Select.from(db,tabPizza)
	.limitBy(5,5)
	.result();

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

Optionally:

Limit dynamicLimit=new Limit();
dynamicLimit.setOffset(16);
dynamicLimit.setLimit(8);
		
Select.from(db,tabPizza)
	.limitBy(dynamicLimit)
	.result();