Get the Max ID of a Table Grouped by Member ID in Laravel

The query builder also provides a variety of methods for retrieving aggregate values like count , max , min , avg , and sum .

Example 1: Laravel Group By with Max ID

/**
* Write code on Method
* Devloped By www.pakainfo.com
* @return response()
*/
public function index()
{
$records = MemberSalary::select('id', 'member_id', DB::raw('MAX(id) as max_id'))
->where('is_reward', 1)
->groupBy('member_id')
->get();

dd($records);
}

Example 2: Laravel Group By with Max Date

Laravel Group By with Max Value Query

/**
* Write code on Method
* Devloped By www.pakainfo.com
* @return response()
*/
public function index()
{
$records = MemberSalary::select('id', 'member_id', DB::raw('MAX(reward_date) as max_reward_date'))
->where('is_reward', 1)
->groupBy('member_id')
->get();

dd($records);
}

Example 3: Laravel Group By with Max Value

/**
* Write code on Method
* Devloped By www.pakainfo.com
* @return response()
*/
public function index()
{
$records = MemberSalary::select('id', 'member_id', DB::raw('MAX(rank) as max_rank'))
->where('is_reward', 1)
->groupBy('member_id')
->get();

dd($records);
}

I hope you get an idea about laravel groupby.

• This blog post was originally published at: https://www.pakainfo.com

#sql  #mysql #laravel