Re: Fetching last n records from Posgresql

On 30 March 2016 at 11:36, Deole, Pushkar (Pushkar) <pdeole(at)avaya(dot)com>
wrote:

> I am sorry I didn’t clarify my requirement properly.. I want the ‘n’
> oldest records, however, they should sorted with the recent record first
> and I want this to happen in the query itself so I don’t have to care about
> sorting through the application..
>
>
>
> *From:* pgsql-general-owner(at)postgresql(dot)org [mailto:
> pgsql-general-owner(at)postgresql(dot)org] *On Behalf Of *Moreno Andreo
> *Sent:* Wednesday, March 30, 2016 3:03 PM
> *To:* pgsql-general(at)postgresql(dot)org
> *Subject:* Re: [GENERAL] Fetching last n records from Posgresql
>
>
>
> Il 30/03/2016 11:19, Deole, Pushkar (Pushkar) ha scritto:
>
> 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)
>
> so remove "desc", in order to have ascending ordering, thus first 5
> records are the five oldest:
>
> select * from t order by record_date limit 5
>
> Cheers
> Moreno.-
>
> Slight modification then...

select * from (select * from t where record_date>now()-'30 day'::interval
order by record_date limit 5) as t order by record_date desc;

Regards,
Sándor

Ezt az e-mailt egy Avast védelemmel rendelkező, vírusmentes számítógépről
küldték.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>