Laravel 8 Group By Query Example

Websolutionstuff | Nov-29-2021 | Categories : Laravel PHP MySQL

In this example we will see laravel 8 group by query example. how to use group by in laravel 8. As you might expect, the groupBy and having methods may be used to group the query results. learn how to create a collection of data using Laravel groupBy method. It can allow us to group the data by types, id, date etc.

Also I will give yoy example of laravel 8 group by with where clause and query of group by in mysql. The GROUP BY statement is often used with aggregate functions COUNT()MAX()MIN()SUM()AVG() to group the result-set by one or more columns.

So, let's start how to use group by in laravel 6, laravel 7 and laravel 8.

SQL Query :

Group By Syntax :

SELECT column_names
FROM table_name
WHERE condition
GROUP BY column_names
ORDER BY column_names;

 

 

SELECT COUNT(user_id), country
FROM users
GROUP BY country;

 

Laravel Query :

The “Group By” function belongs to the collection, not eloquent category.

use App\User;
use DB;

public function index()
{
    $users = User::select("*", DB::raw("count(*) as user_id"))
                    ->groupBy('country')
                    ->get();
}

 

Laravel groupBy() with having() query example :

The having method's signature is similar to that of the where method.

$users = DB::table('users')
                ->groupBy('account_id')
                ->having('account_id', '>', 100)
                ->get();

 

 

Laravel groupBy() with Date

Now, I will give you example of group by date or group by year.

DB::table('users')
      ->select(DB::raw('DATE(created_at) as date'), DB::raw('count(*) as views'))
      ->groupBy('date')
      ->get();

 

$users = User::select("*", DB::raw("count(*) as user_count"))
                        ->groupBy(DB::raw("year(created_at)"))
                        ->get();

 


You might also like :

Recommended Post
Featured Post
How To Image Upload With Progress Bar Angular 15
How To Image Upload With Progr...

As an Angular 15 developer, I understand the importance of incorporating image upload functionality with a progress bar...

Read More

Jun-21-2023

Laravel 8 Many To Many Relationship Example
Laravel 8 Many To Many Relatio...

In this example we will see laravel 8 many to many relationship example. Use many to many relationship in lara...

Read More

Nov-15-2021

Drag and Drop File Upload Using Dropzone js in Laravel 8
Drag and Drop File Upload Usin...

This article will show drag and drop file upload using dropzone js in laravel 8. DropzoneJS is an open-source library th...

Read More

Oct-20-2020

Laravel 9 Vue 3 Image Upload Example
Laravel 9 Vue 3 Image Upload E...

In this article, we will see the laravel 9 vue 3 image upload example. Here we will learn vue 3 image upload using vite...

Read More

Nov-16-2022