[shanondink]

If you only want to get 12,000 records returned from your query, look into the Oracle rownum() function.

NS told me about it and I googled it and found a lot of info. From what google turns up, you should be able to take your existing SQL select statement and wrap another select statement around it:

SELECT * FROM () WHERE rownum() .”

I was told that the NS Open Access Parser does not allow subqueries in the FROM clause.

So you’ll need to do something like this:

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() This is a cached copy. Click here to see the original post.

[Author]

Posts