Hi, i am trying to query all the data from my table in batches, e.g i have 10000 rows that i want to collect by 10 callls to db, each one will bring 1000 rows. so i will end up with 10000 rows, without duplications and row missing. i dont have any uniqe index or column in this table.
in mysql/postgres i am using the quey: SELECT * FROM myTable offset x limit y, where y is the size of each batch. and x is the count of the rows i collected so far. i tried using rank() and row_number() with qualify, but it only help if i have a unique index or column. there is any solution for me ?