Skip and take all?

Question

In eloquent, how can I skip 10 rows and then get the rest of the table?

User::skip(10)->all();

The above does not work, but it gives you an idea what I am looking for.

Answer 1

Try this:

$count = User::count();
$skip = 10;

User::skip($skip)->take($count - $skip)->get();

With one query:

User::skip($skip)->take(18446744073709551615)->get();

It's ugly, but it's an example from official MySQL manual:

To retrieve all rows from a certain offset up to the end of the result set, you can use some large number for the second parameter. This statement retrieves all rows from the 96th row to the last:

SELECT * FROM tbl LIMIT 95,18446744073709551615;

Answer 2

try something like this it work for sure..

$temp = User::count();
$count = $temp - 10;

$data = User::take($count)->skip(10)->get();