Hi Desmond, there is no such thing like MySQL's LIMIT syntax in SAP DB. There is indeed the ROWNO predicate (http://www.sapdb.org/htmhelp/8c/ccce30c71c11d2a97100a0c9449261/content.htm), but this is applied *before* an order by is applied (similar to Oracle 7.3), so it may or may not have use for you.
How to achieve a similar application behaviour depends heavily on the interface you are using, and how do you fetch the data of a result set into the application. Normally you should use the positioning methods of the interface on a result set (for Java those navigation methods (absolute, relative, ...) in ResultSet) and then start to fetch your 10 or whatever rows. Regards Alexander Schr�der SAP Labs Berlin > -----Original Message----- > From: Desmond [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 27, 2002 6:12 PM > To: [EMAIL PROTECTED] > Subject: help > > > How can I get the limit row from the result set using the SAPDB. What > actually I want to do is like this. I get 1000 over result > set after I do > the SELECT transaction from the databse and I want to display > the result for > 20 row per page that's mean 0-20 row for 1st page, 11-40 row > for second page > and so on. So, can I do that using the SAPDB? I have go > through the SAPDB > Doc and I still cannot get the answer. > > Thanks. > Desmond > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
