I need to write an SQL statement that selects 100 rows of data starting from the Xth row.

ROWCOUNT = 100; SELECT * FROM tablename

will get 100 rows, but how to instruct it not to start at the top of the table??

thanks
/d8/