Basic Pagination - Page by Page

basic

E-commerce product listing shows 10 products per page. Implement page navigation.

-- Page 1: First 10 products

SELECT product_id, product_name, price

FROM products

ORDER BY price DESC

LIMIT 10 OFFSET 0;

-- Page 2: Next 10 products (skip first 10)

SELECT product_id, product_name, price

FROM products

ORDER BY price DESC

LIMIT 10 OFFSET 10;

-- Page 3: Next 10 products (skip first 20)

SELECT product_id, product_name, price

FROM products

ORDER BY price DESC

LIMIT 10 OFFSET 20;

-- Formula: OFFSET = (page_number - 1) * page_size

-- Page 2 results:

product_id | product_name | price

11 | Laptop Pro | 1299.99

12 | Tablet Ultra | 899.99

13 | Smartphone X | 799.99

... (7 more rows)

LIMIT controls page size, OFFSET skips previous pages. Always use ORDER BY for consistent pagination. Formula: OFFSET = (page - 1) × page_size. Essential for scalable UI data loading.

All

Top-N Queries - Best Performers

basic

Sales dashboard needs top 5 salespeople by revenue for monthly recognition

SELECT

salesperson_id,

first_name,

last_name,

monthly_revenue,

deals_closed

FROM salespeople

ORDER BY monthly_revenue DESC

LIMIT 5;

-- Alternative: Top 10% of salespeople