Did you ever wonder how pagination works in SQL? A recent article by Kasir Barati sheds light on the magic behind it. In his post, he explains how to implement pagination using raw SQL and provides a step-by-step guide.

To illustrate the concept, he uses an example of fetching part of data from a table called "news_articles" according to a WHERE clause, OFFSET, and LIMIT. The article also touches on calculating previous and next page numbers.

Source: https://dev.to/kasir-barati/pagination-in-raw-sql-1eke