On 30 March 2016 at 11:36, Deole, Pushkar (Pushkar) <pde...@avaya.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-ow...@postgresql.org [mailto: > pgsql-general-ow...@postgresql.org] *On Behalf Of *Moreno Andreo > *Sent:* Wednesday, March 30, 2016 3:03 PM > *To:* pgsql-general@postgresql.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>
