Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
select * from t order by record_date desc limit 5; this will return the recent 5 records.. what I want is the oldest 5 records (in last 30 days) From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of John R PierceSent: Wednesday, March 30, 2016 12:38 PMTo: pgsql-general@postgresql.orgSubject: Re: [GENERAL] Fetching last n records from Posgresql On 3/29/2016 11:40 PM, Deole, Pushkar (Pushkar) wrote: WITH t AS ( SELECT * FROM mytable ORDER BY record_date ASC LIMIT 5)SELECT * FROM t ORDER BY record_date DESC; why do it twice when you can just do.... select * from t order by record_date desc limit 5;-- john r pierce, recycling bits in santa cruz
select * from t order by record_date desc limit 5;
this will return the recent 5 records.. what I want is the oldest 5 records (in last 30 days)
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of John R PierceSent: Wednesday, March 30, 2016 12:38 PMTo: pgsql-general@postgresql.orgSubject: Re: [GENERAL] Fetching last n records from Posgresql
On 3/29/2016 11:40 PM, Deole, Pushkar (Pushkar) wrote:
WITH t AS ( SELECT * FROM mytable ORDER BY record_date ASC LIMIT 5)SELECT * FROM t ORDER BY record_date DESC;
WITH t AS (
SELECT * FROM mytable ORDER BY record_date ASC LIMIT 5
)
SELECT * FROM t ORDER BY record_date DESC;
why do it twice when you can just do.... select * from t order by record_date desc limit 5;-- john r pierce, recycling bits in santa cruz
john r pierce, recycling bits in santa cruz
В списке pgsql-general по дате отправления: