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 Use Soft Delete to Temporary (Trash) Delete the Records in Laravel

Use Soft Delete to Temporary (Trash) Delete the Records in Laravel 9 ?

June 14, 2022June 14, 2022

Soft delete in laravel is use to hide the record from users by keeping the data in the database. In laravel we use Soft Delete to Temporary (Trash) Delete the Records. There is many purpose of soft delete like deleting the user for admin but keep all the information in…

Read More
Php Laravel 11 CRUD Example Tutorial with Search, Image and Pagination

Laravel 11 CRUD Example Tutorial with Search, Image and Pagination

July 5, 2024July 5, 2024

In this article, we’ll delve into Laravel and explore the implementation of CRUD operations alongside essential features like Search, Image uploading, and Pagination. CRUD, an acronym for Create, Read, Update, and Delete, forms the backbone of database management in web applications across all programming paradigms. This tutorial covers these fundamental…

Read More
Php Laravel slug generator using trait

Laravel reusable slug generator using trait

November 8, 2021November 8, 2021

In our last article Laravel slug generator with example we demonstrate how we can generate slug for model but in that article we need to rewrite the same code for multiple models if we want use the slug generation in multiple model. so in this article i will show you…

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

  • 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

  • Understanding High Vulnerabilities: A Deep Dive into Recent Security Concerns
  • Understanding High Vulnerabilities in Software: A Week of Insights
  • Blocking Spam Requests with LaraGuard IP: A Comprehensive Guide
  • Enhancing API Development with Laravel API Kit
  • Exploring the Future of Web Development: Insights from Milana Cap
©2023 Readerstacks | Design and Developed by Readerstacks
Go to mobile version