selecting number of rows from resultset
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.
selecting number of rows from resultset
===

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.