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