LIMIT and OFFSET for pagination in MySQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to limit the query to 5 rows.

MySQL

SELECT * FROM products [1] 5;

Drag options to blanks, or click blank then click option'

AOFFSET

BWHERE

CLIMIT

DORDER BY

Attempts:

3 left

💡 Hint

Common Mistakes

Using OFFSET instead of LIMIT to restrict rows.

Using WHERE without a condition.

Using ORDER BY without specifying columns.

The LIMIT clause restricts the number of rows returned by the query. Here, LIMIT 5 returns only 5 rows.

2fill in blank

medium

Complete the code to skip the first 10 rows and return the next 5 rows.

MySQL

SELECT * FROM products [1] 5 OFFSET 10;

Drag options to blanks, or click blank then click option'

AWHERE

BLIMIT

CORDER BY

DGROUP BY

Attempts:

3 left

💡 Hint

Common Mistakes

Using OFFSET without LIMIT.

Using WHERE instead of LIMIT.

Placing OFFSET before LIMIT.

The LIMIT clause specifies how many rows to return, and OFFSET skips the first rows. Here, LIMIT 5 OFFSET 10 skips 10 rows and returns the next 5.

3fill in blank

hard

Fix the error in the query to paginate results correctly.

MySQL

SELECT * FROM orders LIMIT [1] OFFSET 20;

Drag options to blanks, or click blank then click option'

A10

B20

C30

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using LIMIT 20 OFFSET 20 returns 20 rows after skipping 20, which may be too many.

Using LIMIT 0 returns no rows.

Using LIMIT 30 returns more rows than needed.

The query should return 10 rows after skipping 20. Using LIMIT 10 OFFSET 20 correctly paginates the results.

4fill in blank

hard

Fill both blanks to select 15 rows starting from the 5th row.

MySQL

SELECT * FROM customers [1] 15 [2] 5;

Drag options to blanks, or click blank then click option'

ALIMIT

BOFFSET

CWHERE

DORDER BY

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping LIMIT and OFFSET keywords.

Using WHERE instead of OFFSET.

Omitting LIMIT.

Use LIMIT 15 OFFSET 5 to get 15 rows starting after skipping 5 rows.

5fill in blank

hard

Fill all three blanks to paginate the 'employees' table: skip 25 rows, return 10 rows, ordered by 'id'.

MySQL

SELECT * FROM employees [1] id [2] 10 [3] 25;

Drag options to blanks, or click blank then click option'

AORDER BY

BLIMIT

COFFSET

DGROUP BY

Attempts:

3 left

💡 Hint

Common Mistakes

Placing OFFSET before LIMIT.

Using GROUP BY instead of ORDER BY.

Omitting ORDER BY when paginating.

The query orders rows by id, then limits to 10 rows, skipping the first 25 rows using ORDER BY id LIMIT 10 OFFSET 25.