Skip to content
Readerstacks logo Readerstacks
  • Home
  • Softwares
  • Angular
  • Php
  • Laravel
  • Flutter
Readerstacks logo
Readerstacks
Laravel max in eloquent query

Laravel max in eloquent query with example

Aman Jain, January 23, 2022November 7, 2023

In this article we will learn to use aggregate function max in laravel eloquent and query builder. Laravel itself provide inbuilt method to max the columns like in MySQL or SQL based database we can do max of columns using max aggregate function.

Laravel eloquent or query builder max method do the same as aggregate function. Laravel max accepts one parameter as column name.

Here is the syntax

Model::max(COLUMN_NAME);

//or

Model::select(\DB::raw("MAX(COLUMN_NAME), other_columns "))->get(); // or first() 

//or

\DB::table('table_name')->max(COLUMN_NAME);

//or

\DB::table('table_name')->select(\DB::raw("MAX(COLUMN_NAME), other_columns "))->first()

In the above syntax we have used 4 examples to show all possibilities to use max aggregate function in laravel.

First is using the Model and max method of eloquent. Second is Model with select and Db::raw class.

In the third example we have used QueryBuilder DB class and table function to use max method of it.

And final example is query builder with select and db raw to use Max method of MySQL or SQL.

Result of above query will be:

select MAX(column_name) from  `table`  

//OR

select MAX(column_name), other_columns from `table`
 

Laravel max using native eloquent and raw query

Let’s understand laravel max in eloquent query with example

Example 1 – Laravel max aggregate function query using eloquent max method

So in this example i will use laravel query builder or eloquent max method to do the max of column.

<?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::max('like_count');
       \\or
       DB::table('articles')->max('like_count');
   }
}

Output will be :

select max(`like_count`) from `articles`

Example 2 – Laravel max query using raw query

In this example i will use laravel query builder DB::raw method with select to max the column

<?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(\DB::raw('max(like_count), aticles.*'))->get();
     
       \\or
        $Article = Article::selectRaw( 'max(like_count), articles.*')->get();
     
      \\OR
       DB::table('articles')->select(\DB::raw('max(like_count), articles.*'))->first();
   }
}

In the above example we have used articles table and created a model in our laravel application. Then we imported the necessary classes and used the max method.

Output will be :

select max(`like_count`), `aticles`.`*` from `articles`

Also Read : Laravel sum in eloquent query with example

Related

Php Laravel laravelmaxmysql

Post navigation

Previous post
Next post

Related Posts

Php How to print raw sql query in eloquent laravel

How to print raw sql query in eloquent laravel ?

November 23, 2022March 16, 2024

In this article we will learn to print raw sql query in eloquent laravel. Sometime to debug the MySQL query in laravel eloquent we need to echo raw sql query and want to know exact query. In laravel we have multiple methods to print database query in laravel 8 and…

Read More
Php How to compress and reduce image size while uploading in laravel

How to compress and reduce image size while uploading in laravel 9 ?

May 14, 2022May 15, 2022

While uploading the images in our application user can upload big size image but storing and rendering big size of image can reduce the performance of the application therefor its an important aspect to reduce the size of image without resizing it so we can keep the original size and…

Read More
Php Laravel 11 Ajax Image Upload with form with example

Laravel 11 Ajax Image Upload with form with example

July 16, 2024July 16, 2024

In this tutorial, I will demonstrate how to implement Laravel 11 Ajax Image Upload with form. This can be achieved using Laravel’s file and storage providers. In our previous articles, such as How to Upload image in Laravel 11 ? we explained how to upload images without Ajax. However, today…

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