Is there a way one can specify the number of rows to be selected.
Reason being I'm displaying results in multiple pages.

Say I want to select rows 20-30 from the recordset.

Currently I'm using a variable to keep track of the FromRow and scrolling to that Row, however is there a way to directly jump to that row?

how you do (effectively) will depend on the particular database system you're using

in MySQL, you can use LIMIT 19,11

there's nothing in standard SQL

What bout MS SQL Server?

see, this is why it helps to post in the correct forum -- the SQL forum is not for Microsoft SQL Server, it is for the SQL language

see http://rosca.net/writing/articles/serverside_paging.asp

You could look into using a cursor. Fetch the number of rows you want. If you want some more rows, leave the cursor open and fetch some more.