which is the optimized way for server-side pagination in SQL using DENSE_RANK() or OFFSET?
OFFSET Query:
DENSE_RANK():