selecting number of rows from resultset

Question

Suppose a query "select * from employee" returns 80 rows. I need to display middle rows that is from 20th row to 50th row.

I know, like to display first 20 rows we have option like "select top 20 * from employee" but if we need middle rows how to get it in MS SQL specifically.

I m new to this SQL queries...Can anybody answer to this question.

Answer 1

This is already answered here. :-)