topic Re: select top n in Application Development and Automation Discussions

select top n

Former Member — Mon, 21 May 2007 17:07:34 GMT

Hello,

I was wondering if it was possible to limit the amount of lines selected from a table.

I tried select top n, as it works in SQL, but SAP doesn 't support this syntax..

Is this doesn't work, is there any other way to limit the amount of data selected ?

suresh_datti — Mon, 21 May 2007 17:08:30 GMT

use the SELECT UP to n ROWS option.

~Suresh

Former Member — Mon, 21 May 2007 17:10:41 GMT

Hi,

Use select upto n rows

Select * from MARA into table ITAB UPTO 10 rows.

select top 10 rows in table.

Regards

SAB

Former Member — Tue, 22 May 2007 06:42:37 GMT

Hi everyone,

thanks for the answers. It is noted in my documentation.

points awarded !

Former Member — Mon, 28 Apr 2008 21:41:54 GMT

I have a similiar question: is there some keyword equivalent to the SQL LIMIT keyword?

I need to retrieve an arbitrary range of rows (rows from row no. a to row no. b, a <b ) to implement result set paging.