buildOrderByAndLimit() public method
Builds the ORDER BY and LIMIT/OFFSET clauses and appends them to the given SQL.
public string buildOrderByAndLimit ( $sql, $orderBy, $limit, $offset ) | ||
---|---|---|
$sql | string |
The existing SQL (without ORDER BY/LIMIT/OFFSET) |
$orderBy | array |
The order by columns. See \yii\db\mssql\Query::orderBy for more details on how to specify this parameter. |
$limit | integer |
The limit number. See \yii\db\mssql\Query::limit for more details. |
$offset | integer |
The offset number. See \yii\db\mssql\Query::offset for more details. |
return | string |
The SQL completed with ORDER BY/LIMIT/OFFSET (if any) |
Please login to continue.