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

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();