在SQLServer2005中可这么写（设table1表有字段id）：select * from ( select *, row_number() over(order by id) as rowNo from table1 ) as temp where rowNo between 3 and 5
