API Pagination Calculator
Enter total records and page size to get page count, offsets, and example REST and SQL snippets.
Total pages: 13
First 10 pages (offset, limit, record range)
- Page 1: offset=0, limit=20 → records 1–20
- Page 2: offset=20, limit=20 → records 21–40
- Page 3: offset=40, limit=20 → records 41–60
- Page 4: offset=60, limit=20 → records 61–80
- Page 5: offset=80, limit=20 → records 81–100
- Page 6: offset=100, limit=20 → records 101–120
- Page 7: offset=120, limit=20 → records 121–140
- Page 8: offset=140, limit=20 → records 141–160
- Page 9: offset=160, limit=20 → records 161–180
- Page 10: offset=180, limit=20 → records 181–200
SQL example (page 2)
-- Page 2, page size 20 SELECT * FROM items ORDER BY id LIMIT 20 OFFSET 20;
REST example
GET /api/items?page=2&page_size=20 # or offset-based: GET /api/items?offset=20&limit=20
Related tools
Learn APIs on Tagna Learn.
Explore Tagna