'What is the best way to paginate redshift queries?

What is the best way to paginate redshift query results?

pagination amazon-redshift

Solution 1:^[1]

SELECT * FROM my_table ORDER BY N LIMIT N OFFSET N

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Joshua Cook