Skip to content
Readerstacks logo Readerstacks
  • Home
  • Softwares
  • Angular
  • Php
  • Laravel
  • Flutter
Readerstacks logo
Readerstacks
Laravel group by with example

How to use laravel group by with example ?

Aman Jain, January 22, 2022January 22, 2022

MySQL group by is used to group same column value multiple rows into one row so to create the group by query we used groupBy method. laravel groupBy method accepts single and multiple parameter as column name.

In this article i will show you to use groupBy in multiple ways, laravel also provide to pass raw query to group so we can pass multiple parameter to group by.

Here is the syntax of groupBy

Article::select("status")->groupBy('status');  // uses mysql group by method and more performant

//or

Article::select("status")->groupBy(DB::raw('status as is_active'))->first();  // uses mysql group by method but we can pass raw sql query

SQL of above query will be

select status from `table` group by status

//OR

select statusfrom `table` group by status as is_active

So let’s understand laravel group by rows with example

Example 1 – Laravel groupBy method with single column

In this example I will show to use MySQL group by method in laravel eloquent. groupBy can accept multiple column and we will pass single column in this example

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\User;
  
class ArticleController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $Article = Article::select("*")->groupBy('status');
      \\or
      DB::table('articles')->groupBy("status");

   }
}

Output will be :

select `statsu` from `articles` group by `status`

Example 2 – Laravel group by with multiple column

In this example I will show to use laravel eloquent group by method with multiple column in group by

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\User;
  
class ArticleController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $Article = Article::select("select","is_active")->groupBy("select","is_active");
         
    }
}

Output will be :

select `status`,`is_active` from `articles` group by `status`,`is_active`

Here we passed multiple parameter to groupBy method which is acceptable by laravel eloquent and query builder

Example 3 – Laravel group by with raw query

Sometimes we need to pass raw query like count or some aggregate function in group by query so we can use as below

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\User;
  
class ArticleController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $Article = Article::select("select")->groupBy(\DB::raw('status as newstatus'));
         
    }
}

Output will be :

select `status` from `articles` group by status as newstatus

I hope this makes clear to you.

Also read : How to use laravel count rows with example ?

Related

Php Laravel groupbylaravelmysql

Post navigation

Previous post
Next post

Related Posts

Php How to Create Rest APIs in Laravel

How to Create Rest APIs in Laravel ?

July 4, 2022August 2, 2022

Rest APIs are used to create the communication between client and server and in this application we will learn to create rest apis in laravel. Rest API is a architectural style which same as both server and client end so any client can consume the apis since it has industry…

Read More

How to increase maximum file upload size in php ?

August 24, 2021August 24, 2021

Php is the most used language in web. sometimes it required to upload the files which is greater then 2 mb. In php default upload size is 2 mb and if we wanted to increase it then we have multiple ways to change the size of uploading. 1. Change from…

Read More
Laravel Image Conversion to WebP in the fly Laravel

Image Conversion to WebP in the fly Laravel

February 22, 2024March 16, 2024

Are you looking to optimize your web application’s image handling and delivery speed? In the world of web development Image Conversion to WebP in the fly Laravel is key, and one of the ways to achieve faster loading times for images is by using the WebP format. Laravel, a popular…

Read More

Aman Jain
Aman Jain

With years of hands-on experience in the realm of web and mobile development, they have honed their skills in various technologies, including Laravel, PHP CodeIgniter, mobile app development, web app development, Flutter, React, JavaScript, Angular, Devops and so much more. Their proficiency extends to building robust REST APIs, AWS Code scaling, and optimization, ensuring that your applications run seamlessly on the cloud.

Categories

  • Angular
  • CSS
  • Dart
  • Devops
  • Flutter
  • HTML
  • Javascript
  • jQuery
  • Laravel
  • Laravel 10
  • Laravel 11
  • Laravel 9
  • Mysql
  • Php
  • Softwares
  • Ubuntu
  • Uncategorized

Archives

  • June 2025
  • May 2025
  • April 2025
  • October 2024
  • July 2024
  • February 2024
  • January 2024
  • December 2023
  • November 2023
  • October 2023
  • July 2023
  • March 2023
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021

Recent Posts

  • The Resilience of Nature: How Forests Recover After Fires
  • Understanding Laravel Cookie Consent for GDPR Compliance
  • Understanding High Vulnerabilities: A Critical Overview of the Week of May 12, 2025
  • Installing a LAMP Stack on Ubuntu: A Comprehensive Guide
  • Understanding High Vulnerabilities: A Deep Dive into Recent Security Concerns
©2023 Readerstacks | Design and Developed by Readerstacks
Go to mobile version