Skip to main content

LIMIT & Pagination

Learn LIMIT & Pagination (SELECT Queries, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction LIMIT n returns at most n rows; LIMIT n OFFSET m (or LIMIT m, n ) skips m rows first. Together with ORDER BY it implements paging, "top N" and sampling.

More lessons in SELECT Queries