Lets understand what is limit and offset in Laravel
Limit and offset in Laravel is used to get certain number of rows from the database table. Let’s say, there are 100 records in the table ‘XYZ’ and you want to get only 10 records from first row to 10th row. In such case we use offset and limit in Laravel eloquent.
Here is the example how we can set limit and offset.
$members = Members::where('status', 'active') ->offset(0) //// start from first row. ->limit(10) //// to 10th row. ->get();
Please note that, above example will work only if your Laravel version is greater than or equal to 5.3