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