Received: from localhost.localdomain (unknown [208.255.226.178])
	by postgresql.org (Postfix) with ESMTP id A07B1475CA2
	for <pgsql-sql@postgreSQL.org>; Wed, 24 Jul 2002 13:58:32 -0400 (EDT)
Received: from localhost (localhost [[UNIX: localhost]])
	by localhost.localdomain (8.11.6/8.11.6) id g6OHuoB02223;
	Wed, 24 Jul 2002 13:56:50 -0400
Content-Type: text/plain;
  charset="iso-8859-1"
From: Chris Ruprecht <chrup@earthlink.net>
Organization: MMRD
To: "Leao Torre do Vale" <elefante400@hotmail.com>, <pgsql-sql@postgreSQL.org>
Subject: Re: Last record
Date: Wed, 24 Jul 2002 13:56:50 -0400
User-Agent: KMail/1.4.1
References: <OE70wdVVxUC4pAn8hEA000123f0@hotmail.com>
In-Reply-To: <OE70wdVVxUC4pAn8hEA000123f0@hotmail.com>
Cc: Jan Wieck <JanWieck@Yahoo.com>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200207241356.50196.chrup@earthlink.net>
X-Archive-Number: 200207/388
X-Sequence-Number: 8766

Select * from <tablename> where <...> desc limit 1;

Desc =3D from the bottom up, limit 1 =3D 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