Web Tools tools.bryantsmith.com

Database & SQL

SQL Pagination Calculator

Enter a page number and page size to get the exact LIMIT/OFFSET for your query, plus a ready-to-run statement and a plain-English explanation of the boundary cases. Everything runs in your browser.

Runs in your browser v1.0.0

Page & size

live

Used for the page count and last-page checks. Leave blank if you only need LIMIT/OFFSET.

Result

live

LIMIT — rows per page
OFFSET — rows to skip 



                

                    
                    
                

            

        

    


    

        

            
Boundary cases

            live
        

        

            

        

    


    

        

            
How it works

        

        

            

                Offset pagination skips a fixed number of rows and then takes the page size:
                OFFSET = (page − 1) × page size. Page numbers are 1-based, so
                page 1 starts at OFFSET 0. Without an ORDER BY the database
                is free to return rows in any order, which can duplicate or skip rows between pages.
                All calculations happen in your browser and nothing is sent anywhere.
            

        

    




Related tools
  • Database Schema Diff ViewerCompare two CREATE TABLE schema definitions and highlight structural changes in tables, columns, indexes and foreign keys.
  • JOIN VisualizerVisualize INNER, LEFT, RIGHT, FULL and CROSS joins against tiny example tables, entirely in your browser.
  • MySQL Date Expression BuilderBuild common MySQL date ranges, intervals, and comparison clauses visually and copy a ready-to-paste WHERE expression.
  • Pagination CalculatorCalculate page counts, offsets, limits, item ranges, and pagination URLs for any paged list.
  • SQL FormatterBeautify SQL for common dialects with live formatting, configurable keyword case and copy or download output.
  • SQL Identifier ConverterNormalize field and table names into snake_case, camelCase, PascalCase and other SQL naming conventions, entirely in your browser.
More Database & SQL tools