The query builder also provides a variety of methods for retrieving aggregate values like count , max , min , avg , and sum .
/**
* 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);
}
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);
}
/**
* 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.