Laravel 9 Order By Query Example

Websolutionstuff | Mar-28-2022 | Categories : Laravel PHP MySQL

In this article, we will see laravel 9 order by query example. how to use order by in laravel 9.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 you an example of laravel 9 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 order by in laravel 9, laravel 9  order by multiple, laravel 9 order by desc, how to use order by in laravel 9,  laravel 9 order by with where clause, order by in MySQL

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

MySQL Order By Syntax.

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

Example :

SELECT * FROM users
ORDER BY name;

 

 

Laravel 9 orderBy Query :

In laravel, you can use the orderBy method for ordering records.

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

 

Laravel 9 orderBy Multiple :

Now, we will see multiple orderBy in a single query.

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

 

 

Laravel 9 orderBy Date Desc :

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

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

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

 

Laravel 9 orderBy with Relationship :

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

 

 

Laravel 9 orderBy with Limit :

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

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

 


You might also like :

Recommended Post
Featured Post
Dependent Dropdown In Laravel 9 Vue JS
Dependent Dropdown In Laravel...

In this article, we will see a dependent dropdown in laravel 9 vue js. Here, we will learn how to create a dependent dro...

Read More

Dec-15-2022

Laravel where and orWhere Condition Example
Laravel where and orWhere Cond...

In this article, we will see laravel where and orWhere condition example. we will give you a very simple example of...

Read More

Jan-11-2021

Laravel 9 CRUD With Image Upload Example
Laravel 9 CRUD With Image Uplo...

In this article, we will see the laravel 9 crud with an image upload example. Here, we will learn how to image upload wi...

Read More

Dec-09-2022

Laravel 9 Socialite Login with Facebook Account
Laravel 9 Socialite Login with...

In this article, we will see laravel 9 socialite login with a facebook account. Many websites provide different typ...

Read More

Apr-16-2022