Documentation

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

ParameterDescriptionVersion
$sqlSQL text.
$limitMaximum number of rows to return.
$offsetOffset of the first row to return, starting from 0.

Exceptions

Examples



© «Bitrix24», 2001-2022
Up