Hi,

select unique(a.NMBREVENTID), a.STRNAME
from bb_tradeshow a , bb_trade_category b
where a.nmbreventid = b.nmbreventid and a.nmbreventid=28;

This query returns 5000 rows. I am calling this sql from client application. I wanted to display only 20 rows at a time.
Everytime this query returns 5000 rows.

Is there anyway in SQL i can give condition to return first 20 then second 20 onwards.
Is it procedure is required for that.

Your help is greatly appreciated!.

Thanks

Padsp