Selecting the last 2 rows of a table

Поиск
Список
Период
Сортировка
От Machiel Richards
Тема Selecting the last 2 rows of a table
Дата
Msg-id 1289295288.2280.28.camel@machielr-laptop
обсуждение исходный текст
Ответы Re: Selecting the last 2 rows of a table  (Thom Brown <thom@linux.com>)
Re: Selecting the last 2 rows of a table  (Majid Azimi <majid.merkava@gmail.com>)
Re: Selecting the last 2 rows of a table  (Frank Bax <fbax@sympatico.ca>)
Список pgsql-novice
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.


Regards
Machiel

В списке pgsql-novice по дате отправления:

Предыдущее
От: Vaduvoiu Tiberiu
Дата:
Сообщение: Delete low priority equivalent in postgresql?
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Selecting the last 2 rows of a table