limiting the number of rows displayed

Hello all,

I am working with a fairly large database (some tables have over 100,000
rows).  Wondering if there is a way to limit the number of rows that can
be viewed when I do   "view data".  Could not see that as an option in
the program.

Thanks

karim