Say the first scene: my system is using the oracle database, system synchronization data come from others they use PostgreSQL,
Synchronization in general idea is: first to their library check total number of data that needs to be synchronized to come over, then paging query is inserted into the oracle,
Is that the script for the query PGSQL:

 SELECT T. * FROM AAA LIMIT 1000 OFFSET 0 

,
But found that every time this article found out only 999, paging parameters not write like this? For the first time to use PGSQL, local did not install the database, are directly to formal environment, found behind a missing data every time