Group by multiple columns using SQL Laravel
In this Post We Will Explain About is Group by multiple columns using SQL Laravel With Example and Demo.
Welcome on infinityknow.com – Examples ,The best For Learn web development Tutorials,Demo with Example! Hi Dear Friends here u can know to laravel collection groupby
In this post we will show you Best way to implement database – Group by multiple columns in Laravel, hear for How to laravel sum multiple columns with Download .we will give you demo,Source Code and examples for implement Step By Step Good Luck!.
database – Group by multiple columns in Laravel
Sometimes you may require to Simple add group by with Laravel multiple columns, if you create have mysql query then you simple can do it shotly by using my sql query. But if you steps to want to give multiple columns or more collection in groupBy() of PHP Laravel Query Builder simple then you may give by simple comma separated differents values as bellow simple example.
[php]
$data = DB::table(“products”)
->select(
‘products.*’
,DB::raw(“SUM(products.quantity) as total_quantity”))
->groupBy(‘products.id_item’,’products.id_cat’)
->get();
print_r($data);
[/php]
Counting and Grouping Database Records Using Laravel
[php]
$activeUsers = \DB::table(‘todolists’)
->select(‘product_id’, \DB::raw(‘count(*) as livetotal’))
->whereYear(‘created_at’, ‘=’, 2016)->whereMonth(‘created_at’, ‘=’, 4)
->groupBy(‘product_id’)
->orderBy(‘livetotal’, ‘desc’)
->get();
[/php]
When simple executed, the source code following SQL will be run:
[php]
select `product_id`, count(*) as livetotal
from `products`
where year(`cr_date`) = ? and month(`created_at`) = ?
group by `product_id`
order by `livetotal` desc”
[/php]
I hope you have Got Group by multiple columns using Laravel And how it works.I would Like to have FeadBack From My Blog(infinityknow.com) readers.Your Valuable FeadBack,Any Question,or any Comments abaout This Article(infinityknow.com) Are Most Always Welcome.