I’m having an issue with running a paged query on my azure database. It works when there is no limit or offset and when there is just a limit, but when I try with a limit and offset it returns an error that their’s an incorrect syntax.
With no offset:
With an offset of 10:
Because it says it’s an incorrect syntax near 20, and the only place 20 shows up is in the “last” array for the offset parameter is there an issue with the way the server connect is sending the paged query to the Azure SQL database?