Laravel Group By with Min Value Query Example

This post will give you example of laravel group by with min value. you can understand a concept of laravel group by min value. This article goes in detailed on laravel group by min(id). let’s discuss about laravel collection group by min.

If you want to get records with group by query and you need to get minimum date, min id, min value or min number then how you will do it. generally group by get first record, but if you need min value records then i will show you some simple query example and you can fix your problem.

you can use this query in laravel 6, laravel 7 and laravel 8 version.

let’s see some example query:

Example 1: Laravel Group By with Min ID

/**

* Write code on Method

*

* @return response()

*/

public function index()

{

$data = UserPayment::select('id', 'user_id', DB::raw('MIN(id) as min_id'))

->where('is_paid', 1)

->groupBy('user_id')

->get();

dd($data);

}

Example 2: Laravel Group By with Min Date

/**

* Write code on Method

*

* @return response()

*/

public function index()

{

$data = UserPayment::select('id', 'user_id', DB::raw('MIN(paid_date) as min_paid_date'))

->where('is_paid', 1)

->groupBy('user_id')

->get();

dd($data);

}

Example 3: Laravel Group By with Min Value

/**

* Write code on Method

*

* @return response()

*/

public function index()

{

$data = UserPayment::select('id', 'user_id', DB::raw('MIN(amount) as min_amount'))

->where('is_paid', 1)

->groupBy('user_id')

->get();

dd($data);

}

i hope it can help you…

1 thought on “Laravel Group By with Min Value Query Example”

Leave a Comment