| protected newBuildOrderByAndLimit ( string $sql, array $orderBy, integer $limit, integer $offset ) : string | ||
| $sql | string | the existing SQL (without ORDER BY/LIMIT/OFFSET) |
| $orderBy | array | the order by columns. See [[\yii\db\Query::orderBy]] for more details on how to specify this parameter. |
| $limit | integer | the limit number. See [[\yii\db\Query::limit]] for more details. |
| $offset | integer | the offset number. See [[\yii\db\Query::offset]] for more details. |
| return | string | the SQL completed with ORDER BY/LIMIT/OFFSET (if any) |
protected function newBuildOrderByAndLimit($sql, $orderBy, $limit, $offset)
{
$orderBy = $this->buildOrderBy($orderBy);
if ($orderBy === '') {
// ORDER BY clause is required when FETCH and OFFSET are in the SQL
$orderBy = 'ORDER BY (SELECT NULL)';
}
$sql .= $this->separator . $orderBy;
// http://technet.microsoft.com/en-us/library/gg699618.aspx
$offset = $this->hasOffset($offset) ? $offset : '0';
$sql .= $this->separator . "OFFSET {$offset} ROWS";
if ($this->hasLimit($limit)) {
$sql .= $this->separator . "FETCH NEXT {$limit} ROWS ONLY";
}
return $sql;
}