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.

Parameter	Description	Version
$sql	SQL text.
$limit	Maximum number of rows to return.
$offset	Offset of the first row to return, starting from 0.