Skip site navigation (1) Skip section navigation (2)

only the last 3 records

From: "Alain Roger" <raf(dot)news(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: only the last 3 records
Date: 2008-09-27 07:13:48
Message-ID: 75645bbb0809270013saee5b88p5043634039f3638c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Hi,

maybe it's a stupid question, but i do not remember how to query a table and
to request only the latest 3 added records.
How can i do that (i have a field time and a field date) ?

thx.

-- 
Alain
------------------------------------
Windows XP SP3
PostgreSQL 8.2.4 / MS SQL server 2005
Apache 2.2.4
PHP 5.2.4
C# 2005-2008

Responses

pgsql-general by date

Next:From: A. KretschmerDate: 2008-09-27 07:23:01
Subject: Re: only the last 3 records
Previous:From: vkDate: 2008-09-27 01:11:18
Subject: Re: circular stderr logging - truncation issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group