How to implement limit restrisction for select

[Former Member]

I want to select only a max row number of a DB table as

select * from DBTABLE

limit 200 (inly the firt 200 rows).

Any suggest?

[Former Member]

I want to select only a max row number of a DB table as

select * from DBTABLE

limit 200 (inly the firt 200 rows).

Any suggest?

[Former Member]

hii

use package size

select * from xyz package size 500.

reward if useful

vikaas

[Former Member]

u can use pakage size or u can use key word UPTO...

REGARDS,

[Former Member]

use UPTO <rows>

Ex.

Select * UP TO 200 ROWS

INTO.....

[former_member673464]

hi..

You can use keyword <b>upto</b> or <b>package size</b> to restrict the number of records.

regards,

veeresh