Re: Last record

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Leao Torre do Vale <elefante400(at)hotmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Last record
Date: 2002-07-24 17:42:16
Message-ID: 3D3EE6F8.C9563D16@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Leao Torre do Vale wrote:

> How can select one field of last
> record of table?

There is no such thing as the "last record of a table" in SQL. Somehow
you must be able to describe what you mean with "last record" and how to
identify that. This would then be translated into a qualification (WHERE
clause) and is the answer to your question.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

  • Last record at 2002-07-24 14:36:40 from Leao Torre do Vale

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-07-24 17:43:02 Re: [SQL] Readline ... a lot of problems...
Previous Message Christian Lbeck 2002-07-24 17:24:52 Function using more than one database