In this article, we will see laravel 8 order by query example. how to use order by in laravel 8.The orderBy method allows you to sort the results of the query by a given column. The first argument accepted by the orderBy method should be the column you wish to sort by, while the second argument determines the direction of the sort and may be either asc or desc.

Also, we will see an example of laravel 8 order by with where clause and query of order by in MySQL or multiple order by in one query. The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.

So, let's see how to use order by in laravel 6, laravel 7, and laravel 8 or laravel 8 order by with where clause.

• SQL Query of Order By
• Laravel orderBy
• Laravel orderBy Multiple
• Laravel orderBy Date Desc
• Laravel orderBy with Relationship
• Laravel orderBy with Limit

SQL Order By Syntax:

SELECT column1, column2
FROM table_name
ORDER BY column1, column2 ASC|DESC;

 

 

SELECT * FROM users
ORDER BY name;

 

In this example, we will use the orderBy() function to retrieve data. 

$users = DB::table('users')
                ->orderBy('name', 'desc')
                ->get();

 

Now, we will see multiple order by in a single query.

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

 

In this example, we will see the date orderBy query example.

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

User::orderBy('updated_at', 'ASC')->get();

 

 

 For example, your Post model belongs to the User model, and you want to get posts data order by updated_at. You can get it like this. 

$users = User::with(['posts' => function ($query) {
    $query->orderBy('updated_at', 'asc');
}])->get();

 

The limit methods to limit the number of results returned from the query.

$users = User::orderBy('id', 'desc')->limit(7)->get(); 
 
$users = User::orderBy('id', 'asc')->limit(7)->get();

 

---

You might also like:

• Read Also: How To Use Sweetalert2 In Laravel
• Read Also: Carbon Add Days To Date In Laravel
• Read Also: Laravel 8 Datatables Filter with Dropdown
• Read Also: Laravel where and orWhere Condition Example