Select

Select single row:

Pizza p=Select.one(db,tabPizza)
	.where(tabPizza.colName(),"Pepperoni").result();

Select row collection:

								
List<Pizza> list=Select.from(db,tabPizza).where(tabPizza.colName(),LIKE,"%Pepperoni%").result();
	

Select single column:

String name=Select.one(db,tabPizza.colName())
	.where(tabPizza.colPizzaId(),EQ,5).result();

Select column collection:

List<String> names=Select.from(db,tabPizza.colName())
	.where(tabPizza.colPizzaId(),GT,5).result();

Select projection:

Projection projection=Select.one(db,tabPizza.colName(),tabPizza.colPizzaId())
	.where(tabPizza.colPizzaId(),EQ,10).result();

Select projection collection:

ProjectionBox box=Select.from(db,tabPizza.colName(),tabPizza.colPizzaId())
	.where(tabPizza.colPizzaId(),LT,10).result();

Inner select:

List<Pizza> list=Select.from(db,tabPizza)
 .whereSelect(tabPizza.colPizzaId(),IN,
  Select.fieldList(tabPizzaPrice.colPizzaId())
   .where(tabPizzaPrice.colPrice(),GT,10.0))
 .result();