# Paginating

**URL:** <https://www.ruby-forum.com/t/paginating/144447>\
**Category:** Rails\
**Created:** [July 29, 2008, 7:14pm UTC](https://www.ruby-forum.com/t/paginating/144447 "2008-07-29T19:14:34Z")\
**Posts on this page:** 3\
**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 29, 2008, 7:14pm UTC](https://www.ruby-forum.com/t/paginating/144447/1 "2008-07-29T19:14:34Z")

</div>

Hi,

I’ve just stumbled across ‘will\_paginate’, and I was wondering if anyone  
knows if I could use a ‘find\_by\_sql’. The problem I’m facing is: I want  
to paginate, but I only want to list the maximum row in each group.

Is this possible? Or is there any better way to do it?

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 29, 2008, 9:56pm UTC](https://www.ruby-forum.com/t/paginating/144447/2 "2008-07-29T21:56:35Z")

</div>

from will\_paginate source code:

# Example:

# 

# @developers = Developer.paginate\_by\_sql ['select \* from developers

where salary \> ?’, 80000], :page =\> params[:page], :per\_page =\> 3

---

<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 29, 2008, 10:17pm UTC](https://www.ruby-forum.com/t/paginating/144447/3 "2008-07-29T22:17:34Z")

</div>

PP Junty wrote:

> from will\_paginate source code:
> 
> # Example:
> 
> # 
> 
> # @developers = Developer.paginate\_by\_sql ['select \* from developers
> 
> where salary \> ?’, 80000], :page =\> params[:page], :per\_page =\> 3

Great, looks promising. How would I find the most recent timestamp?  
‘where max(created\_at’) ?

Thanks!!