newBuildOrderByAndLimit() protected method
Builds the ORDER BY/LIMIT/OFFSET clauses for SQL SERVER 2012 or newer.
| protected string newBuildOrderByAndLimit ( $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.