Laravel Eloquent groupByRaw() Query Example

Admin   Laravel   321  2021-03-15 18:10:04

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.....