# Offset and limit in sqlserver2005

**URL:** <https://www.ruby-forum.com/t/offset-and-limit-in-sqlserver2005/123395>\
**Category:** Rails\
**Created:** [December 17, 2007, 10:44am UTC](https://www.ruby-forum.com/t/offset-and-limit-in-sqlserver2005/123395 "2007-12-17T10:44:04Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![shiva](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/85e7bf/32.png) [@shiva](https://www.ruby-forum.com/u/shiva)\
**Post date:** [December 17, 2007, 10:44am UTC](https://www.ruby-forum.com/t/offset-and-limit-in-sqlserver2005/123395/1 "2007-12-17T10:44:04Z")

</div>

Hi,  
I am using sqlserver2005 as my database.I am facing problem in when i  
give limit and offset in the query.

Eg : @books=Book.find(:all,  
:limits=\>1,:offset=\>2  
)

SELECT \* FROM (SELECT TOP 1 \* FROM (SELECT TOP 2 id,name FROM books  
WHERE ( status=‘Approved’) ) AS tmp1 ) AS tmp2

query is executing like this…its not working…if any one knows how to  
use limits and offsets in sqlserver2005