Count

Count entities:

SQL: select count(*) from pizza Pizza where pizza.name in('CAPRICIOSA','PEPPERONI'); 
Long count=Select.entityList(daoPizza)
	.where(daoPizza.colName(),Operator.IN,Arrays.asList("CAPRICIOSA","PEPPERONI")))
	.countAny();

Count unique:

SQL: select unique count(*) from pizza Pizza where pizza.id=4 and pizza.name='CAPRICIOSA'; (MySQL)
Long count=Select.entityList(daoPizza).where(Where.AND()
	.and(daoPizza.colPizzaId(),Operator.EQUAL,4)
	.and(daoPizza.colName(),Operator.EQUAL,'CAPRICIOSA'))
	.unique()
	.countAny();