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.