In this article, we will see the laravel orderBy, groupBy, and limit examples. Here we will see different types of laravel 6/7/8 query examples. You can use the order by, group by, and limit functions for getting records from the database.
So, let's see the query of orderBy in laravel 7 and laravel 8, the query of the group by in laravel 7/8, and get a limited no of records in laravel 7/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.
Laravel Example:
$users = DB::table('users')
->orderBy('name', 'desc')
->get();
SQL Query:
select * from `users` order by `name` desc;
Output:
All user's names will be sorted in descending order.
The groupBy
and having
methods may be used to group the query results. The having
method's signature is similar to that of the where
method.
$users = DB::table('users')
->groupBy('account_id')
->having('account_id', '>', 100)
->get();
The limit method is used to limit the number of results returned from the query.
$users = DB::table('users')
->limit(5)
->get();
Hey there! So, you're working with PHP and trying to fetch content from an HTTPS URL using the file_get_contents() f...
Mar-01-2024
In this article, we will see how to row group in datatable in jquery. Datatables doesn't have row grouping buil...
Jun-04-2022
In this article, I will guide you through the process of installing the php-zip extension on Ubuntu. The php-zip extensi...
Jul-14-2023
In this article, I will guide you through the process of installing php-bcmath on Ubuntu. Php-bcmath is a PHP extension...
Jul-12-2023