Database, Data Engineering, Dbms, Data Modeling, Data Management.
(select unique_value as max_value from records_tbl order by unique_value limit 1 offset 9999) as previous_data where records_tbl.unique_value > previous_data.max_value order by unique_value limit 100; Implementation Typical OLTP databases perform incremental ID matching by their transaction