Abfrage mit Aggregration
| ID | 284 | ||||
|---|---|---|---|---|---|
| Link Reference | Not set | ||||
| Link Credits | Not set | ||||
| Link Technical Documentation | Not set | ||||
| PlCodelang | Yii2 | ||||
| PlGroup | Datenbank | ||||
| PlItemTitle | Abfrage mit Aggregration | ||||
| Code | <?php /* // Example as SQL SELECT FieldA ,COUNT(FieldA) as cnt FROM MainTable WHERE FieldA = 5 GROUP BY FieldA */ $MainTableResultQry = MainTable::find() ->select(['FieldA', 'COUNT(FieldA) as cnt']) ->where(['FieldA' => 5]) ->groupBy(['FieldA']) ->createCommand() ->queryAll(); ?> | ||||
| Result Example |
| 1500 | 5 |$MainTableResultQry[0 => ['FieldA' => 1000, 'cnt' => 23], 1 => [['FieldA' => 1500, 'cnt' => 5]]] |