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

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

  • Total 1 Answer
  • 320
Can You answer this question?
author
,
Aspirant Programmer

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.