ODBC Pagination

NetSuite ODBC uses Oracle SQL, hence the ROWNUM function can be used to get into the subset of records.

Example 1:

SELECT * FROM CUSTOMERS WHERE ROWNUM BETWEEN 6 AND 10
 
Example 2:

SELECT * FROM TRANSACTIONS WHERE
TRANSACTION_ID > 145000
AND
(
TRANSACTION_TYPE = 'Invoice' OR
TRANSACTION_TYPE = 'Sales Order' OR
TRANSACTION_TYPE = 'Payment' OR
TRANSACTION_TYPE = 'Purchase Order' OR
TRANSACTION_TYPE = 'Item Fulfillment' OR
TRANSACTION_TYPE = 'Item Receipt'
)
AND rownum()
ORDER BY TRANSACTION_ID;

Which will only return 12,000 rows.