CODE EXAMPLE FOR SQL

sql limit offset

SELECT * FROM "USER"
ORDER BY id_USER ASC OFFSET 9 limit 11; /*will get 10º to 20º row*/