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

Re: Selecting the last 2 rows of a table

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Selecting the last 2 rows of a table
Date: 2010-11-09 12:05:17
Message-ID: 4CD938FD.6070605@sympatico.ca (view raw or flat)
Thread:
Lists: pgsql-novice
Machiel Richards wrote:
> Good day all
> 
>      I am trying to find out how I can select the last 2 or (n amount ) 
> of rows from a specific table.
> 
>       We have a table which has been growing rediculously the last view 
> days (I must say after a code go-live).
> 
>        I am trying to find out what data is being written to the table 
> that is causing this, however due to the size of the table at the 
> moment, it can cause problems so I am just interested in the last number 
> of records.



Compare two backup files.

In response to

pgsql-novice by date

Next:From: Vaduvoiu TiberiuDate: 2010-11-09 13:46:09
Subject: MySql Concat function equivalent
Previous:From: Majid AzimiDate: 2010-11-09 09:48:42
Subject: Re: Selecting the last 2 rows of a table

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