database - Paralelizing a sql query with only ansi sql -

i have clustered application in-memory cache in it. during runtime load data cache database. takes time.

since cache replicated want trigger load process nodes. master node runs sql.

let's have simple table as;

column1 column2

field1 field1 . . .

if have 1000000 rows , 2 nodes, want load first 500000 first node , 500000 second node. if node size get's more number of rows divided node count.

but cannot figure out how limit , partition data using ansi sql standart. have tried rownum syntax different rownum providers.

M16