Uses of Class
io.github.projectunified.craftdatabase.client.sql.helper.SelectBuilder

Packages that use SelectBuilder

Package	Description
io.github.projectunified.craftdatabase.client.sql.helper	Contains builders to construct the most-used SQL queries

Uses of SelectBuilder in io.github.projectunified.craftdatabase.client.sql.helper

Methods in io.github.projectunified.craftdatabase.client.sql.helper that return SelectBuilder

Modifier and Type	Method	Description
SelectBuilder	SelectBuilder.columns(String... columns)	Add columns to select, the default is *
static SelectBuilder	SelectBuilder.create(String table)	Create a new builder
SelectBuilder	SelectBuilder.distinct()	Add the DISTINCT option
SelectBuilder	SelectBuilder.groupBy(String... columns)	Add columns to group by
SelectBuilder	SelectBuilder.having(String condition, Object... values)	Add a condition to the HAVING clause, joined to the previous ones with AND
SelectBuilder	SelectBuilder.join(String join, Object... values)	Add a join clause, e.g.
SelectBuilder	SelectBuilder.limit(int limit)	Set the maximum number of rows
SelectBuilder	SelectBuilder.orderBy(String... orderBy)	Add an order by expression, e.g.
SelectBuilder	SelectBuilder.where(String condition, Object... values)	Add a condition, joined to the previous ones with AND