set rowcount

Excuse the very elementary question . . .

I have a result set > 10000 rows, however, I only want to see 10 rows, not all 10000 rows. How do I set the rowcount, or whatever to only return x # of rows instead of the complete result set.

thanks for your help,
jm

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 31 1999 - 09:06:44 CST