function dbtng_example_execute_group_by_select_query

The code below will result in the following query SELECT ex.pid AS pid, ex.uid AS uid, ex.name AS name, ex.surname AS surname, ex.age AS age FROM {dbtng_example} ex GROUP BY ex.age

Related topics

Example: Database (DBTNG)
Database examples, including DBTNG.
1 call to dbtng_example_execute_group_by_select_query()
dbtng_example_grouping_list in dbtng_example/dbtng_example.module
This function groups the result set by the specified field and render a list of entries in the database

File

dbtng_example/dbtng_example.module, line 642

Code

function dbtng_example_execute_group_by_select_query() {
    $select = db_select('dbtng_example', 'ex');
    // Select these specific fields for the output.
    $select->fields('ex', array(
        'name',
    ));
    // Count('name') how many times same name comes in table .
    $select->addExpression('COUNT(ex.name)', 'count');
    // 'n.name' is used for groupBy clause.
    $select->groupBy("ex.name");
    $output = $select->execute()
        ->fetchAll();
    return $output;
}