select top n

[Former Member]

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 ?

[Former Member]

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]

use the SELECT UP to n ROWS option.

~Suresh

[Former Member]

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]

Hi everyone,

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

points awarded !

[Former Member]

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.