getTopSql

string public
\Bitrix\Main\DB\MssqlSqlHelper::getTopSql(
 string $sql,
 integer $limit,
 integer $offset
);

This non-static method transforms SQL query according to $limit and $offset values.

You must specify $limit parameter when $offset is set.

Parameter	Description	Version
$sql	Sql text.
$limit	Maximum number of strings to be returned.
$offset	Offset of the first row to return, starting from 0.