[James – my-wardrobe.com]

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

[Rajesh Seth]

RE: ODBC SQL limit offset results

select top 10 * from table should work for this.

I was able to get the first 10 employees in the employees table with:

select top 10 * from employees

[ivan.parra]

RE: ODBC SQL limit offset results

also try rownum() < 10

[Author]

Posts