# Will\_paginate

**URL:** <https://www.ruby-forum.com/t/will-paginate/144034>\
**Category:** Rails\
**Created:** [July 24, 2008, 8:05pm UTC](https://www.ruby-forum.com/t/will-paginate/144034 "2008-07-24T20:05:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jturney](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/e99b99/32.png) [@jturney](https://www.ruby-forum.com/u/jturney)\
**Post date:** [July 24, 2008, 8:05pm UTC](https://www.ruby-forum.com/t/will-paginate/144034/1 "2008-07-24T20:05:05Z")

</div>

paginate :per\_page =\> 15, :page =\> page,  
:conditions =\> [‘title like ?’, “%#{search}%”], :order  
=\> ‘requirement\_id DESC, created\_at DESC’

In my table:  
requirement\_id/created\_at  
1/5am  
1/3am  
2/5pm  
2/3pm

How can I specify to only return the first row in each requirement\_id  
group? That is, I only want to paginate 1/3am and 2/3pm because 1/3am is  
the first row in the group requirement\_id = 1…

Thanks!

---

<div class="post-metadata">

**Author:** ![jturney](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/e99b99/32.png) [@jturney](https://www.ruby-forum.com/u/jturney)\
**Post date:** [July 24, 2008, 9:31pm UTC](https://www.ruby-forum.com/t/will-paginate/144034/2 "2008-07-24T21:31:28Z")

</div>

Justin To wrote:

> paginate :per\_page =\> 15, :page =\> page,  
> :conditions =\> [‘title like ?’, “%#{search}%”], :order  
> =\> ‘requirement\_id DESC, created\_at DESC’

I’ve been reading around and I think a solution may be to use the SQL  
‘limit 1’, but where do I stick this in?