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
Re: Selecting the last 2 rows of a table Re: Selecting the last 2 rows of a table |
| Список | 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
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 по дате отправления: