Re: Fetching last n records from Posgresql

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(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of John R Pierce
Sent: Wednesday, March 30, 2016 12:38 PM
To: pgsql-general(at)postgresql(dot)org
Subject: 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