From: Liquid Date: 2006-05-02T13:37:36+09:00 Subject: Re: Find the 3 newest rows in the database ------=_Part_33037_18376137.1146544653749 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline use SQL of SELECT * FROM Adverts ORDER BY created_at DESC LIMIT =3D 3; On 5/2/06, david wrote: > > Hi, > > 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. > > Thanks > > David > > -- > Posted via http://www.ruby-forum.com/. > > ------=_Part_33037_18376137.1146544653749--