Group by in select query

[Philippe-M]

Hello, it's possible in the next release to add a GROUP BY criteria in select query ?

[MejorCodigo]

Medoo already supports Group By, example code from the docs:

$database->select("account", "user_id", [
        // GROUP by single value
    'GROUP' => 'type',

    // GROUP by array of values
    'GROUP' => [
        'type',
        'age',
        'gender'
    ],

    // Must have to use it with GROUP together
    'HAVING' => [
        'user_id[>]' => 500
    ]
]);

https://medoo.in/api/where

[Philippe-M]

oupss, Sorry I had not seen this in the doc.