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]