queryScalar

string|null public
\Bitrix\Main\DB\Connection::queryScalar(
 string $sql,
 array $binds = null
);

This non-static method executes a query, fetches a row and returns single field value from the first column of the result.

Parameter	Description	Version
$sql	SQL query.
$binds	Binded array.