| From: | Chris Ruprecht <chrup(at)earthlink(dot)net> |
|---|---|
| To: | "Leao Torre do Vale" <elefante400(at)hotmail(dot)com>, <pgsql-sql(at)postgreSQL(dot)org> |
| Cc: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
| Subject: | Re: Last record |
| Date: | 2002-07-24 17:56:50 |
| Message-ID: | 200207241356.50196.chrup@earthlink.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-07-24 18:20:40 | Re: RES: RES: [SQL] Queries not using Index |
| Previous Message | Josh Berkus | 2002-07-24 17:43:02 | Re: [SQL] Readline ... a lot of problems... |