public function Select::countQuery in Drupal 9

Same name and namespace in other branches

1. 8 core/lib/Drupal/Core/Database/Query/Select.php \Drupal\Core\Database\Query\Select::countQuery()

Get the equivalent COUNT query of this query as a new query object.

Return value

\Drupal\Core\Database\Query\SelectInterface A new SelectQuery object with no fields or expressions besides COUNT(*).

Overrides SelectInterface::countQuery

File

core/lib/Drupal/Core/Database/Query/Select.php, line 715

Class

Select

Query builder for SELECT statements.

Namespace

Drupal\Core\Database\Query

Code

public function countQuery() {
  $count = $this
    ->prepareCountQuery();
  $query = $this->connection
    ->select($count, NULL, $this->queryOptions);
  $query
    ->addExpression('COUNT(*)');
  return $query;
}