Re: Fetching last n records from Posgresql

 

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