Laravel Eloquent groupByRaw() Query Example

Hi Guys,

In this example,I will learn you how to use groupByRaw() query in laravel.you can easy and simply use groupByRaw() query in laravel.

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.

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);
}

It will help you.....