Builder|Builder unionAll(Builder|Closure $query) Add a union all statement to the query. Parameters Builder|Closure $query Return Value Builder|Builder

Builder|Builder union(Builder|Closure $query, bool $all = false) Add a union statement to the query. Parameters Builder|Closure $query bool $all Return Value Builder|Builder

void truncate() Run a truncate statement on the table. Return Value void

string toSql() Get the SQL representation of the query. Return Value string

Builder toBase() Get a base query builder instance. Return Value Builder

Builder|Builder take(int $value) Alias to set the "limit" value of the query. Parameters int $value Return Value Builder|Builder

Blueprint table(string $table, Closure $callback) Modify a table on the schema. Parameters string $table Closure $callback Return Value Blueprint

mixed sum(string $column) Retrieve the sum of the values of a given column. Parameters string $column Return Value mixed

Builder|Builder skip(int $value) Alias to set the "offset" value of the query. Parameters int $value Return Value Builder|Builder

Paginator simplePaginate(int $perPage = 15, array $columns = array('*'), string $pageName = 'page', int|null $page = null) Get a paginator only supporting simple next and previous links. This is more efficient on larger data-sets, etc. Parameters int $perPage array $columns string $pageName int|null $page Return Value Paginator