Laravel Get Min Value of Column Example

Hi Guys,

Today, I would like to show you laravel get min value of column. If you have a question about laravel get row with min value then I will give a simple example with a solution. we will help you to give an example of get min value of a column in laravel. Here you will learn get min value from collection laravel.

There are several ways to get get minimum id in laravel. i will give you three example using min(), oldest() and orderBy() method. so, let's see the one-by-one example.

Example 1: using min()

app/Http/Controllers/DemoController.php

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\Models\Product;
  
class DemoController extends Controller
{
    /**
     * Write code on Method
     *
     * @return response()
     */
    public function index(Request $request)
    {
        $minID = Product::whereNotNull('price')->min("price");
  
        dd($minID);
    }
}

Output:

70.00

Example 2: using orderBy()

app/Http/Controllers/DemoController.php

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\Models\Product;
  
class DemoController extends Controller
{
    /**
     * Write code on Method
     *
     * @return response()
     */
    public function index(Request $request)
    {
        $minID = Product::whereNotNull('price')->orderBy('price', 'asc')->value('price');
  
        dd($minID);
    }
}

Output:

70.00

I hope it can help you...