How to get last N records with activerecord?

ruby-on-rails ruby activerecord
JtR picture JtR · Jan 7, 2009 · Viewed 137.1k times · Source

With :limit in query, I will get first N records. What is the easiest way to get last N records?

Answer

Bongs picture Bongs · Jan 27, 2012

This is the Rails 3 way

SomeModel.last(5) # last 5 records in ascending order

SomeModel.last(5).reverse # last 5 records in descending order

Related questions

How to drop columns using Rails migration

What's the syntax for dropping a database table column through a Rails migration?

Read More
Rails Active Record find(:all, :order => ) issue

I seem to be unable to use the ActiveRecord::Base.find option :order for more than one column at a time. For example, I have a "Show" model with date and attending columns. If I run the following code: @shows = …

Read More
Rails 4 LIKE query - ActiveRecord adds quotes

I am trying to do a like query like so def self.search(search, page = 1 ) paginate :per_page => 5, :page => page, :conditions => ["name LIKE '%?%' OR postal_code like '%?%'", search, search], order => 'name' end …

Read More