CollectionFind::groupBy

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

CollectionFind::groupBy — Set 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 more columns, frequently this is used with aggregate functions like COUNT,MAX,MIN,SUM etc.

参数

sort_expr

The columns 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 that can be used for further processing

范例

Example #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();

?>
相关文章
php mysql xdevapi collectionfind classphp mysql xdevapi collectionfind bind value to query placeholderphp mysql xdevapi collectionfind collectionfind constructorphp mysql xdevapi collectionfind set document field filterphp mysql xdevapi collectionfind set grouping criteriaphp mysql xdevapi collectionfind set condition for aggregate functionsphp mysql xdevapi collectionfind skip given number of elements to be returnedphp mysql xdevapi collectionfind set the sorting criteriaphp mysql xdevapi collectionmodify set the sorting criteriaphp mysql xdevapi collectionremove set the sorting criteriaphp mysql xdevapi columnresult get character setphp mysql xdevapi crudoperationlimitable set result limitphp mysql xdevapi tabledelete set delete limit offsetphp mysql xdevapi tabledelete set delete sort criteriaphp mysql xdevapi tabledelete set delete search conditionphp mysql xdevapi tableselect set select grouping criteriaphp mysql xdevapi tableselect set limit offsetphp mysql xdevapi tableselect set select sort criteriaphp mysql xdevapi tableselect set select search conditionphp mysql xdevapi tableupdate set sorting criteria
关注编程学问公众号