db\mssql\QueryBuilder buildOrderByAndLimit()

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)

doc_Yii
2016-10-30 16:58:18
Comments
Leave a Comment

Please login to continue.