Find method

Hi, quick question may be simple to answer,
how can I use the find method to get the last 20 entries in my mysql
table:
Sports.find(:(last 20 entries please), :conditions none)

cheers.fishman()

What i do in that case is reverse my order (use ‘id DESC’ for
instance) with a limit (limit 20 in your case) and then reverse the
array of results.

Comment.find(:all, :order => ‘id desc’, :limit => 20).reverse

or something similar.
There may be a better way though.

chers,
vanne