$this distinct() Force the query to only return distinct results. Return Value $this

int delete(mixed $id = null) Delete a record from the database. Parameters mixed $id Return Value int

int decrement(string $column, int $amount = 1, array $extra = array()) Decrement a column's value by a given amount. Parameters string $column int $amount array $extra Return Value int

Generator cursor() Get a generator for the given query. Return Value Generator

Builder|Builder crossJoin(string $table, string $first = null, string $operator = null, string $second = null) Add a "cross join" clause to the query. Parameters string $table string $first string $operator string $second Return Value Builder|Builder

int count(string $columns = '*') Retrieve the "count" result of the query. Parameters string $columns Return Value int

bool chunkById(int $count, callable $callback, string $column = 'id', string $alias = null) Chunk the results of a query by comparing numeric IDs. Parameters int $count callable $callback string $column string $alias Return Value bool

bool chunk(int $count, callable $callback) Chunk the results of the query. Parameters int $count callable $callback Return Value bool

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

mixed average(string $column) Alias for the "avg" method. Parameters string $column Return Value mixed