-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|