From: Pistos Christou <jesusrubsyou.5.pistos@...>
Date: 2006-05-02T13:58:28+09:00
Subject: Re: Find the 3 newest rows in the database

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

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