Level 12
Using the below statement you can group by your results with type and also get the some of each types.
$data= DB::table('expenses')->select([DB::raw('SUM(amount) as total_amount'), 'type'])->groupBy('type')->get();
Oct 23, 2023
2
Level 2
Group query result by type and calculate sum of each group.
I have this query $data= DB::table('expenses') ->select('amount', 'type')->get(); now I want to group each expense by their type and calculate the sum of all the amount that have the same type. How do you think I should go about this?
Level 2
@DhPandya it works, thanks
1 like
Please or to participate in this conversation.