0

How can I pick any group of rows if I know the first and last ID? Suppose the table has IDs from 1 to 10 and I want contentResolver.query to return the rows 4 to 8, how can I do that? I searched for that question, but all I found are solutions to return the first n consecutive rows:

Answer1 Answer2

Community
  • 1
  • 1
Error
  • 820
  • 1
  • 11
  • 34

1 Answers1

0

using LIMIT and OFFSET clauses solution
SELECT * FROM TABLE LIMIT 5 OFFSET 3; reference

Error
  • 820
  • 1
  • 11
  • 34