All Forums Database
oshribin 1 post Joined 10/15
14 Oct 2015
pagination over table

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 ? 

You must sign in to leave a comment.