Laravel Eloquent groupByRaw() Query Example

Hello Devs, 

In this tutorial, we will learn Laravel Eloquent groupByRaw() Query Example

The groupByRaw method may be used to set a raw string as the value of the group by clause. So let’s understand through the query.

Follow this step by step guide below. 

Example 1:

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    $users = User::select('city', 'state')
                   ->groupByRaw('city, state')
                   ->get();
    dd($users);
}

Example 2:

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    $users = DB::table('users')
                ->select('city', 'state')
                ->groupByRaw('city, state')
                ->get();
    dd($users);
}

May this example help you.