# How do I find all entries, except the newest entry, created?

**URL:** <https://www.ruby-forum.com/t/how-do-i-find-all-entries-except-the-newest-entry-created/132665>\
**Category:** Rails\
**Created:** [March 22, 2008, 9:57pm UTC](https://www.ruby-forum.com/t/how-do-i-find-all-entries-except-the-newest-entry-created/132665 "2008-03-22T21:57:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![adistarmid](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/f14d63/32.png) [@adistarmid](https://www.ruby-forum.com/u/adistarmid)\
**Post date:** [March 22, 2008, 9:57pm UTC](https://www.ruby-forum.com/t/how-do-i-find-all-entries-except-the-newest-entry-created/132665/1 "2008-03-22T21:57:59Z")

</div>

I’m looking to do a Post.find(:all) – finding all entries but the  
newest one created. Maybe something in this format, although I’m not  
sure:

Post.find(:all, :order =\> “created\_at DESC”, :conditions =\> “**EXCLUDE  
NEWEST ENTRY CREATED**”])

Any idea?

---

<div class="post-metadata">

**Author:** ![adistarmid](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/f14d63/32.png) [@adistarmid](https://www.ruby-forum.com/u/adistarmid)\
**Post date:** [March 22, 2008, 10:13pm UTC](https://www.ruby-forum.com/t/how-do-i-find-all-entries-except-the-newest-entry-created/132665/2 "2008-03-22T22:13:39Z")

</div>

Bob S. wrote:

> I’m looking to do a Post.find(:all) – finding all entries but the  
> newest one created. Maybe something in this format, although I’m not  
> sure:
> 
> Post.find(:all, :order =\> “created\_at DESC”, :conditions =\> “**EXCLUDE  
> NEWEST ENTRY CREATED**”])

I don’t think you can do with a SQL. Just find all and get rid of it.

Post.find(:all), :order=\>‘created\_at DESC’).shift

or

Post.find(:all), :order=\>‘created\_at’).pop

---

<div class="post-metadata">

**Author:** ![adistarmid](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/f14d63/32.png) [@adistarmid](https://www.ruby-forum.com/u/adistarmid)\
**Post date:** [March 22, 2008, 11:14pm UTC](https://www.ruby-forum.com/t/how-do-i-find-all-entries-except-the-newest-entry-created/132665/3 "2008-03-22T23:14:28Z")

</div>

You could exclude the highest possible id, with :conditions =\> " id !=  
max(id) "

-john