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
Carbon Add Months To Date In Laravel
Carbon Add Months To Date In L...

In this article, we will see an example of carbon add months to date in laravel. Here, we will give you a simple&nb...

Read More

Dec-05-2020

How To Install Yajra Datatable In Laravel 10
How To Install Yajra Datatable...

In this article, we will see how to install datatable in laravel 10. Here, we will learn about the laravel 10 yajra data...

Read More

Mar-01-2023

Laravel 9 Authentication Using Inertia JS
Laravel 9 Authentication Using...

In this article, we will see laravel 9 authentication using inertia js. Here, you can learn how to authenticat...

Read More

Dec-05-2022

How To Validate Username And Password In React JS
How To Validate Username And P...

In this article, we will see how to validate username and password in react js. In this example, we will validate t...

Read More

Sep-13-2022