How to use multiple columns groupby in Laravel Query Builder

Sometimes in our project we must need to add group by with the multiple columns. Today now in this p ost i will show you How to use multiple columns group by in Laravel Query Builder? if we are mysql query then easily we can do this by using sql query. But when we want to give with multiple columns in groupBy() in our Laravel Query Builder then we need to give by using comma separated.

Example:

$data = DB::table("items_count")
	        ->select(
	            'items_count.*'
	            ,DB::raw("SUM(items_count.quantity) as total_quantity"))
	        ->groupBy('items_count.id_item','items_count.id_cat')
	        ->get();
print_r($data);

Read Also : Laravel 8 Mobile Number Verification Tutorial

Thanks for read. I hope it help you. For more you can follow us on facebook

Please leave this field empty

Email Address *

Check your inbox or spam folder to confirm your subscription.