D7 API documentation
What's New
Modules
Main module in old core
addSecondsToDateTime
castToChar
convertDateField
convertDatetimeField
formatDate
getAliasLength
getCharToDateFunction
getColumnTypeByField
getConcatFunction
getConverter
getCurrentDateFunction
getCurrentDateTimeFunction
getDateToCharFunction
getDatetimeToDateFunction
getIsNullFunction
getLeftQuote
getLengthFunction
getQueryDelimiter
getRightQuote
getTopSql
prepareMerge
softCastTextToChar
getTopSql
string public \Bitrix\Main\DB\MysqlCommonSqlHelper::getTopSql( string $sql, integer $limit, integer $offset );
This non-static method transforms SQL query according to$limit
and $offset
limitations.
You must specify $limit
parameter when $offset
is set.
Parameters
Parameter | Description | Version |
---|---|---|
$sql | SQL text. | |
$limit | Maximum number of rows to return. | |
$offset | Offset of the first row to return, starting from 0. |
Exceptions
Examples
© «Bitrix24», 2001-2024
Up