Photo by Caspar Camille Rubin on Unsplash

If you use relational databases day by day, you know that each vendor implement ANSI SQL standard in different ways.

One of the differences is in pagination.

With pagination we mean the way to retrieve data from a result set in chunked way, with a fixed width of chunk.

Each vendor implement this feature in a specifc way.

For example, if you use MySQL databases, a typical paginated query is

SELECT *
FROM table
WHERE condition
LIMIT 10 OFFSET 10

The same query using Oracle RDBMS is

SELECT *
FROM (
SELECT *, rnum AS rownum
FROM table
WHERE rownum <= 20
)
WHERE rnum >10

--

--

Gabriele de Capoa

Gabriele de Capoa

Cloud software engineer, wanna-be data scientist, former Scrum Master. Agile, DevOps, Kubernetes and SQL are my top topics.

Following