From: j`ey <cardologist@...>
Date: 2006-05-02T15:45:15+09:00
Subject: Re: Find the 3 newest rows in the database

david wrote:
> Pistos Christou wrote:
>> david wrote:
>>> I have an Adverts table with a created_at column. I would like to get 
>>> back the 3 newest adverts. How would I do this.
>> 
>> This depends on what you're using, but it's a relatively simple SQL 
>> statement:
>> 
>> SELECT *
>> FROM adverts
>> ORDER BY created_at DESC
>> LIMIT 3;
>> 
>> Are you using DBI?  Straight SQL?  ActiveRecord?  Og?
>> 
>> Pistos
> 
> ActiveRecord

find(:all, :limit => 3, :order => 'created_at DESC')

Check out the Rails mailing list, it would be better to ask these sort 
of questions there.

j`ey
http://www.eachmapinject.com

-- 
Posted via http://www.ruby-forum.com/.