Laravel 8 Order By Query Example

Websolutionstuff | Dec-01-2021 | Categories : Laravel PHP MySQL

In this example 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 I will give yoy 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 start how to use order by in laravel 6, laravel 7 and laravel 8.

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

Order By Syntax :

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



ORDER BY name;


Laravel orderBy Query :
$users = DB::table('users')
                ->orderBy('name', 'desc')


Laravel orderBy Multiple :

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

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


Laravel orderBy Date Desc :

In this example we will see date orderBy query example.

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

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



Laravel orderBy with Relationship :

For example, your Post model belongs to 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');


Laravel orderBy with Limit :

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 :

Recommended Post
Featured Post
How To Check Occupied Disk Space In Laravel
How To Check Occupied Disk Spa...

Many times we need requirements to check the occupied disk space of the server on the admin side and we are checking man...

Read More


Laravel 8 Send Mail using Queue
Laravel 8 Send Mail using Queu...

In this tutorial I will show you laravel 8 send mail using queue, many time we can see some process to take mo...

Read More


Laravel 11 Simple Pagination Example
Laravel 11 Simple Pagination E...

Hello developers! In this article, we'll see the laravel 11 simple pagination example. Here, we'll use Bootstrap...

Read More


How To Create User Roles And Permissions In Laravel 10
How To Create User Roles And P...

In this article, we will see how to create user roles and permissions in laravel 10. Here, we will learn about roles and...

Read More