Good afternoon, can anyone help me with how to implement pagination in advanced SQL, considering that my database is pointed to Oracle
Hi Luiz,
use something like this.
select *
from (
<columns>, row_number() over (order by something unique) rn
from <table> )
where rn between :n and :m
order by rn;
:n starting row
:m ending row
Hope it helps you
Regards
Hi @carl ruhle
I have same issue and then using the expression on table instead do the query. Thank you for the solution, it would make better improvement to up my experience.
Hi @Dadi
if you have an issue, share the statement if possible that we will try our best to help.