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 Change Date Format in Blade View File in Laravel

How to Change Date Format in Blade View File in Laravel ?

September 8, 2022March 16, 2024

Laravel default shows the date in the way its stored in database bu sometimes we want to change date format in blade view file in laravel according to our requirements. It can be multiple possibilities and requirement from client or product manager to change the date format so in this…

Read More
Php get last insert id in laravel

How to get last insert id in laravel with example ?

March 5, 2022February 22, 2024

In this article i will learn you to get last insert id in laravel, In laravel we can execute our queries in two ways first is using the laravel eloquent and other one is DB builder. so in the both pattern we can get the last inserted i in laravel….

Read More
Php How to Show Success and Error Flash Message in Laravel

How to Show Success and Error Flash Message in Laravel 10 ?

March 26, 2023March 16, 2024

This article aims to teach how to display flash messages indicating success or error in Laravel 10. Flash messages come in handy when notifying users of recent activities such as form submissions or website actions. In such cases, multiple types of messages may be required. Sometimes, error messages need to…

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

  • July 2025
  • 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

  • Mapping Together: The Vibrant Spirit of OpenStreetMap Japan
  • Understanding High Vulnerabilities: A Deep Dive into the Weekly Summary
  • Building a Million-Dollar Brand: The Journey of Justin Jackson
  • Mastering Schedule Management with Laravel Zap
  • The Resilience of Nature: How Forests Recover After Fires
©2023 Readerstacks | Design and Developed by Readerstacks
Go to mobile version