Laravel Eloquent groupByRaw() Query Example

Laravel 6 , Laravel , Laravel 7

Nicesnippets

146

25-07-2020


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


Recommended Posts