LIMIT and OFFSET in MySQL

LIMIT — Restrict Rows

SELECT * FROM students ORDER BY marks DESC LIMIT 3;

OFFSET — Skip Rows

SELECT * FROM students LIMIT 5 OFFSET 10;
-- same as
SELECT * FROM students LIMIT 10, 5;

Skips 10 rows, then returns 5 — used for pagination (page 3 of results).

Summary

• LIMIT n = return at most n rows.
• OFFSET skips rows; together they power pagination.

LIMIT — Rows सीमित करें

SELECT * FROM students ORDER BY marks DESC LIMIT 3;

OFFSET — Rows छोड़ें

SELECT * FROM students LIMIT 5 OFFSET 10;
-- वही
SELECT * FROM students LIMIT 10, 5;

10 rows छोड़कर 5 लौटाता है — pagination के लिए (results का page 3)।

सारांश

• LIMIT n = ज़्यादा से ज़्यादा n rows।
• OFFSET rows छोड़ता है; साथ में pagination बनाते हैं।