order by multiple columns in Laravel

• OrderBy method on multiple columns in laravel

  $users = App\Models\User::orderBy('created_at', 'desc')->orderBy('id', 'asc')->get();
  dd($users);
  

  This code snippet will show data in order for columns created_at by DESC and with column id by ASC. It follows the first order by at first and second order by at second priority.

   

  Demo code

  Route::get('/order-by', function(){
      $users = App\Models\User::orderBy('created_at', 'desc')->orderBy('id', 'asc')->get();
      dd($users);
  });

  Just copy/paste code in routes\web.php and visit http://localhost:8000/order-by  after running the php artisan serve in command line.

   

  Output :

  ^ Illuminate\Database\Eloquent\Collection {#1390 ▼
    #items: array:14 [▶]
  }

Back to code snippet queries related laravel