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.

score 2 · Accepted Answer · edited May 23 '17 at 11:47

2

This is already answered here. :-)

edited May 23 '17 at 11:47

Community

1
1

answered Mar 12 '10 at 10:21

Jamie Chapman

4,220
5
28
47

selecting number of rows from resultset

1 Answers1