How to limit # of rows

I was wondering if you could tell me how to limit the total number of rows. I know that there is a “limit=” option, but that cuts off the returned query once you get beyond your “limit.”

I would like to know how to add a “pagination” aspect to that limitation.

Thanks

http://wordpress.org/plugins/abase/