Laravel 9 Group By Query Example

Websolutionstuff | Mar-29-2022 | Categories : Laravel PHP MySQL

In this article, we will see laravel 9 group by query example. how to use group by in laravel 9. 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 9 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 see  how to use group by in laravel 9, laravel 9 group by multiple, laravel 9 group by with where clause, group by in MySQL,  laravel 9 group by date, group by in laravel 9,

SQL Query :

MySQL Group By Syntax with where condition :

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

Example :

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

 

 

Laravel 9 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 9 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 9 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 Send Email In Laravel 9 Using Mailtrap
How To Send Email In Laravel 9...

In this article, we will explore the process of sending emails in Laravel 9 using Mailtrap. We will delve into how Larav...

Read More

Jul-27-2022

PHP Access Modifiers Example
PHP Access Modifiers Example

In this example we will see PHP access modifiers example. In PHP default access modifier is public. PHP provide differen...

Read More

Sep-06-2021

Scrolla - jQuery Plugin for Reveal Animations
Scrolla - jQuery Plugin for Re...

In this tutorial we will see how to use scrolla - jQuery plugin for reveal animations when scrolling a mouse. this jquer...

Read More

Apr-21-2021

Laravel 8 One To Many Polymorphic Relationship
Laravel 8 One To Many Polymorp...

In this tutorial we will learn about laravel 8 one to many polymorphic relationship. A one-to-many polymorphic rela...

Read More

Nov-19-2021