Skip to Content
0
Former Member
Feb 25, 2009 at 08:47 PM

Limiting Select query to given number of hits in select paarameter.

530 Views

Hello,

I have to selec data from a custom table.

SELECT-OPTIONS : S_RECNO FOR ZCUST-RECNO,

parameters: p_maxhit(8).

SELECT * FROM ZCUST into TABLE it_ZCUST

where recno in s_recno.

Now in the select parameters I have option for Maximum data records. How can I limit above selection to maximum hit specified in select parameter (p_maxhit) ?

Regards,

Jainam.