Cake\Database\Query::offset PHP Method

Query Class Documentation Show file Open project: cakephp/cakephp

offset() public method

In some databases, this operation might not be supported or will require the query to be transformed in order to limit the result set size. ### Examples $query->offset(10) // generates OFFSET 10 $query->offset($query->newExpr()->add(['1 + 1'])); // OFFSET (1 + 1)

public offset ( integer \| Cake\Database\ExpressionInterface $num )
$num	integer \| Cake\Database\ExpressionInterface	number of records to be skipped

    public function offset($num)
    {
        $this->_dirty();
        if ($num !== null && !is_object($num)) {
            $num = (int) $num;
        }
        $this->_parts['offset'] = $num;
        return $this;
    }

Query

__clone

__construct

__debugInfo

__toString

_conjugate

_decorateStatement

_dirty

_makeJoin

andHaving

andWhere

bind