Select

[Former Member]

Hi all

I have a report as mentioned below.But i want to select only the first 2 record from the table without using control-break statments.Please help.

Vijay

[Former Member]

hi,

use the following statement

select <your fields>

from <dbtab> " database table

into table <itab> " your internal table

up to 2 rows.

reward if helpful

prasanth

[Former Member]

make use of select upto 2 rows statement if u want to select from dbase

[prasanth_kasturi]

hi,

use the following statement

select <your fields>

from <dbtab> " database table

into table <itab> " your internal table

up to 2 rows.

reward if helpful

prasanth

[Former Member]

Use SELECT UPTO N ROWS statement

[Former Member]

use the following

select field1 field2 field3 ...

from table_name

into itab

upto 2 rows

where .......

Please reward points if this works.

[Former Member]

Hi,

To select 'n' particular no. of records from table then use

select <f1> <f2> from table into itab where condition up to n rows.

Regards,

vineela.