sql select limit range 1

sql select limit range

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

Here is what the above code is Doing:
1. The first query will get the first 10 rows.
2. The second query will get the next 10 rows.
3. The third query will get the next 10 rows.
4. And so on…

Similar Posts