How to get last N records with activerecord

Question

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

Answer 1

Add an :order parameter to the query

Answer 2

An active record query like this I think would get you what you want ('Something' is the model name):

Something.find(:all, :order => "id desc", :limit => 5).reverse

edit: As noted in the comments, another way:

result = Something.find(:all, :order => "id desc", :limit => 5)

while !result.empty?
        puts result.pop
end

Answer 3

an other one solution

SomeModel.all.last(count).reverse