Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
ODBC SQL limit offset results
I'm trying to implement a way of limiting offseting the results in an ODBC sql statement. I've tried using the rownum feature of oracle ie:
SELECT * FROM table WHERE ROWNUM<10
this should get only ten rows from the table. but i get the following error:
'Column:ROWNUM not found.select * FROM ITEMS WHERE ROWNUM < 10'
so i tried another approach:
SELECT * FROM (SELECT ROW_NUMBER() OVER ( ORDER BY
column DESC) LINENUM, * FROM tableWHERE
LINENUM > 0 AND LINENUM <= 50)
this doesnt work either.
Anyone else had this problem or is there another way i can do this?
0