- 01Getting Started
- 02SELECT Statement Basics
- 03Filtering Rows with WHERE
- 04Sorting Results with ORDER BY
- 05Combining Tables with JOIN
- 06Aggregating Data with GROUP BY
- 07Fuzzy Matching with LIKE
- 08Modifying Data with INSERT, UPDATE, and DELETE
- 09Introduction to Subqueries
- 10Creating a VIEW
- 11Ranking Rows with Window Functions
- 12Understanding Transactions
- 13Writing Comments in SQL
- 14Logical Operators: AND, OR, NOT
- 15Working with NULL Values
- 16INNER JOIN vs. LEFT JOIN
- 17Filtering Aggregates with HAVING
- 18Removing Duplicates with DISTINCT
- 19Combining Results with UNION
- 20Conditional Values with CASE
- 21Checking Existence with EXISTS
- 22Changing Table Structure with ALTER TABLE
- 23Self Joins
- 24Speeding Up Searches with INDEX
- 25GROUP BY with Multiple Columns
- 26Pagination with LIMIT and OFFSET
- 27Pattern Matching with GLOB
- 28Date Calculations with the date() Function
- 29Joining Three Tables
- 30Matching Multiple Values with IN
- 31Derived Tables: Subqueries in FROM
- 32The Basics of TRIGGER
- 33Readable Queries with WITH (CTEs)
- 34UPSERT: Insert or Update in One Statement
- 35Combining MIN, MAX, and AVG
- 36Restricting Input with CHECK Constraints
- 37Auto-Numbering with AUTOINCREMENT
- 38Inspecting Query Plans with EXPLAIN QUERY PLAN
- 39ORDER BY with Multiple Columns
- 40Conditional Aggregation with CASE
- 41Removing Objects with DROP TABLE and DROP VIEW
- 42Combining Multiple CTEs
- 43Date Range Search with BETWEEN
- 44Finding What's Missing with NOT EXISTS
- 45Substituting NULL with COALESCE
- 46String Functions: UPPER, LENGTH, and SUBSTR
- 47Converting Types with CAST
- 48Merging Grouped Values with GROUP_CONCAT
- 49Enforcing Integrity with FOREIGN KEY
- 50Capstone: Build a Mini Library Management System
Pagination with LIMIT and OFFSET
This lesson covers pagination with LIMIT and OFFSET, so you can split a large result set across pages. It's for anyone searching "SQL LIMIT OFFSET tutorial."
LIMIT count caps how many rows come back, and OFFSET count sets how many rows to skip before starting — together, they power "show 10 results per page" style pagination.
The example uses ORDER BY score DESC LIMIT 2 OFFSET 2; to grab just the 3rd and 4th rows from a score-descending list. Try changing the OFFSET value to see how you can freely fetch "the next page."
A common early mistake is miscounting what OFFSET actually skips — OFFSET 2 means "skip 2 rows," so results start from the 3rd row; it helps to map out the formula between page number and offset (page 1 is OFFSET 0, etc.) so it doesn't get confusing. Fetching an entire large dataset at once would overwhelm both the server and the browser, so nearly every real web service uses this pagination pattern — an e-commerce product listing is the classic example.
💡 The SQL engine may take a few seconds to load the first time you run code.