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.
Order By Syntax :
SELECT column1, column2
FROM table_name
ORDER BY column1, column2 ASC|DESC;
SELECT * FROM users
ORDER BY name;
$users = DB::table('users')
->orderBy('name', 'desc')
->get();
Now, we will see multiple order by in single query.
User::orderBy('name', 'DESC')
->orderBy('email', 'ASC')
->get();
In this example we will see date orderBy query example.
User::orderBy('created_at', 'DESC')->get();
User::orderBy('updated_at', 'ASC')->get();
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 :
Here you will learn how to get random records from DB in laravel using the inRandomOrder() method. Explore an...
Nov-10-2023
In this article, we will see how to change the table name using laravel 10 migration. Here, we will learn about the...
Apr-28-2023
In this article, we will see how to generate QR code in angular 13. In this example, we will use the angularx-qrcod...
Jun-09-2022
In this article, we will see to fixed class "DOMDocument" not found in laravel. Also, class 'domdocum...
Feb-17-2023