topic Re: Select in Application Development and Automation Discussions

Select

Former Member — Tue, 20 May 2008 07:39:42 GMT

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 — Tue, 20 May 2008 07:54:25 GMT

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

prasanth_kasturi — Tue, 20 May 2008 07:58:52 GMT

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 — Tue, 20 May 2008 07:58:52 GMT

Use SELECT UPTO N ROWS statement

Former Member — Tue, 20 May 2008 08:52:04 GMT

use the following

select field1 field2 field3 ...

from table_name

into itab

upto 2 rows

where .......

Please reward points if this works.

Former Member — Tue, 20 May 2008 09:39:40 GMT

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.