Laravel 8 OrderBy Query Example

Hi,

Today, i we will show you laravel 8 OrderBy query example. This article will give you simple example of laravel 8 OrderBy query example. you will learn laravel 8 OrderBy query example.

how to use laravel 8 orderby with relation, orderbydate, orderbydesc, orderbydesc limit, orderbyasc, all(), random, created_at, raw etc. And multiple orderby in one query. So let’s follow few step to create example of laravel 8 OrderBy query example.

Laravel 8 Eloquent Group By Example

OrderBy Example
OrderBy Multiple Example
OrderBy DESC Example
OrderByDesc() Example
OrderByRaw() Example
OrderByRaw() with DESC Example
Orderby Belongs to Relationship Example
Orderby with Limit Example

Step 1:- OrderBy Example

// orderby desceding
$users = User::orderBy('id', 'desc')->get();
  
// orderby ascending
$users = User::orderBy('id', 'asc')->get();

Step 2:- OrderBy Multiple Example

$users = User::orderBy('name', 'DESC')
    ->orderBy('email', 'ASC')
    ->get();

Step 3:- OrderBy DESC Date Example

1	`User::orderBy('created_at',` `'DESC')->get();`

Step 4:- OrderByDesc() Example

$users = User::select("*")
                       ->where("status", 1)
                       ->orderByDesc("name")
                       ->get();

Step 5:- OrderByRaw() Example

$users = User::select("*")
                        ->where("status", 1)
                        ->orderByRaw("concat(first_name, ' ', last_name)")
                        ->get();

Step 6:- OrderByRaw() with DESC Example

$users = User::select("*")
                        ->where("status", 1)
                        ->orderByRaw("concat(first_name, ' ', last_name) DESC")
                        ->get();

Step 7:- Orderby Belongs to Relationship Example

// asceding 
$posts = Post::with(['author' => function ($q){
                        $q->orderBy('name');
                    }])
                    ->get();
  
// desceding
$posts = Post::with(['author' => function ($q){
                        $q->orderBy('name', 'DESC');
                    }])
                    ->get();

Step 8:- Orderby with Limit Example

// desceding 
$users = User::Orderby('id', 'desc')->limit(5)->get();
  
// asceding 
$users = User::Orderby('id', 'asc')->limit(5)->get();