Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

upto 1 row

Former Member
0 Kudos

what happen if upto 0 rows used.

6 REPLIES 6

Former Member
0 Kudos

You get all records from database ..

Check the below code :

data i_mara like mara occurs 0 with header line.

select * from mara into table i_mara up to 0 rows.

Thanks

Seshu

0 Kudos

hi Seshu Maramreddy

do n't use occurs 0 use with out header internal tables.

0 Kudos

from the database all records fetched into internal table you used in select statement.

try once.

<b>reward if Helpful </b>

Former Member
0 Kudos

Hi,

It will show all records.

Thanks.

Former Member
0 Kudos

Hi

The 'SELECT .... UP TO 1 ROWS' statement is subtly different. The database selects all of the relevant records that are defined by the WHERE clause, applies any aggregate, ordering or grouping functions to them and then returns the first record of the result set.

but when u write upto 0 then it will show all the records fetched in the internal table

reward if usefull

Former Member
0 Kudos

It will shows all records in the table.