How to get records from certain offset up to the end of result set in MySql?

Write down a query to get records from certain offset up to the end of result set in MySql?

To get the all records from a specific offset up to the end of the result set, use the below MySql query and will solve your problem.

The query retrieves all rows from the 95th row to the last:

SELECT * FROM tbl LIMIT 94,18446744073709551615;

You would be thinking why this large number has been specified but it is mentioned in MySql official document. Actually it is larger than the length of integer.