On 9 November 2010 09:34, Machiel Richards
<machielr@rdc.co.za> 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.
I would appreciate any assistance in this.
Well, you'll have to decide what determines the order of your tuples. If you have a column bound to a sequence, and that is considered to put them in order, then it would be
SELECT my_columns
FROM my_table
ORDER BY sequence_column DESC
LIMIT 2
Or you could replace that with a date field if appropriate. But whatever column you use, you'd need an index on it.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935