select * from foo_table order by oid desc limit 1;
>From: Chris Ruprecht <[EMAIL PROTECTED]> >To: "Leao Torre do Vale" ><[EMAIL PROTECTED]>,<[EMAIL PROTECTED]> >CC: Jan Wieck <[EMAIL PROTECTED]> >Subject: Re: [SQL] Last record >Date: Wed, 24 Jul 2002 13:56:50 -0400 > >Select * from <tablename> where <...> desc limit 1; > >Desc = from the bottom up, limit 1 = just one record. > >Best regards, >Chris > >On Wednesday 24 July 2002 10:36 am, Leao Torre do Vale wrote: > > Dear Sir, > > > > If you already have the answer of the question below please, send to me. > > > > Best Regards > > > > Leao > > > > Maputo - Mozambique > > > > How can select one field of last > > record of table? > > > > (ex: SELECT LAST ....) > > > > Thanks > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
