For example, there are a total of 10 pieces of data with IDs 1-10, and now I want to query the 5 pieces of data after the specified ID based on the passed ID,
For example, if the incoming id is 1, the data with id 1,2,3,4,5 will be queried.
If the id is 3, the id will be 3,4,5,6. 7 data
How to write?Thank you
Take the users table as an example:
where id >=1 and id <=5
where id >=3 and id <=7