PHP 8.1.28 Released!

CollectionFind::groupBy

(No version information available, might only be in Git)

CollectionFind::groupBySet grouping criteria

说明

public mysql_xdevapi\CollectionFind::groupBy(string $sort_expr): mysql_xdevapi\CollectionFind

This function can be used to group the result set by one or more columns. It is often used with aggregate functions such as COUNT, MAX, MIN, SUM etc.

参数

sort_expr

The column or columns that have to be used for the group operation, this can either be a single string or an array of string arguments, one for each column.

返回值

A CollectionFind object that can be used for further processing.

示例

示例 #1 mysql_xdevapi\CollectionFind::groupBy() example

<?php

// Assuming $coll is a valid Collection object

// Extract all the documents from the Collection and group the results by the 'name' field
$res = $coll->find()->groupBy('name')->execute();

?>
add a note

User Contributed Notes

There are no user contributed notes for this page.
To Top