Which rows are returned when using LIMIT with OFFSET in MySQL?

by

It will return 18 results starting on record #9 and finishing on record #26.

Start by reading the query from offset. First you offset by 8, which means you skip the first 8 results of the query. Then you limit by 18. Which means you consider records 9, 10, 11, 12, 13, 14, 15, 16….24, 25, 26 which are a total of 18 records.

Check this out.

And also the official documentation.

More Related Contents:

  1. mysql_fetch_array() expects parameter 1 to be resource, boolean given in [closed]
  2. How to group by two rows in a column
  3. How to perform grouped ranking in MySQL
  4. How to abort INSERT operation in MySql trigger?
  5. Mysql or/and precedence?
  6. MySQL “Group By” and “Order By”
  7. CHECK constraint in MySQL is not working
  8. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  9. Migrate from Oracle to MySQL
  10. Which is more efficient: Multiple MySQL tables or one large table?
  11. Are there disadvantages to using a generic varchar(255) for all text-based fields?
  12. How to subtract hours from a datetime in MySQL?
  13. MySQL “IN” operator performance on (large?) number of values
  14. Advanced MySql Query: Update table with info from another table
  15. storing money amounts in mysql
  16. MySQL CREATE FUNCTION Syntax
  17. Difference between two table structure
  18. MySQL sum elements of a column
  19. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  20. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  21. Why MySQL is giving error “Not allowed to return a result set from a function”?
  22. How to store decimal in MySQL?
  23. MySQL cumulative sum grouped by date
  24. Where I can find a list of “mysqldump” exit codes?
  25. Strip last two characters of a column in MySQL
  26. Automatic Rollback if COMMIT TRANSACTION is not reached
  27. MySQL cartesian product between two SELECT statements
  28. Sum until certain point – MySql
  29. mysql double-quoted table names
  30. Speeding up mysql dumps and imports [closed]

Leave a Comment