Re: Fetching last n records from Posgresql

<div class="moz-cite-prefix">Il 30/03/2016 11:19, Deole, Pushkar (Pushkar) ha scritto:<br /></div><blockquote
cite="mid:78A4D6BFBAA5BA49A5E94DA00A6A76E309864466@AZ-FFEXMB04.global.avaya.com"type="cite"><style><!--
 
/* Font Definitions */
@font-face{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face{font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New
Roman","serif";color:black;}
a:link, span.MsoHyperlink{mso-style-priority:99;color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed{mso-style-priority:99;color:purple;text-decoration:underline;}
pre{mso-style-priority:99;mso-style-link:"HTML Preformatted
Char";margin:0in;margin-bottom:.0001pt;font-size:10.0pt;font-family:"CourierNew";color:black;}
 
span.HTMLPreformattedChar{mso-style-name:"HTML Preformatted Char";mso-style-priority:99;mso-style-link:"HTML
Preformatted";font-family:"Consolas","serif";color:black;}
span.EmailStyle19{mso-style-type:personal-reply;font-family:"Calibri","sans-serif";color:#1F497D;}
.MsoChpDefault{mso-style-type:export-only;font-size:10.0pt;}
@page WordSection1{size:8.5in 11.0in;margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1{page:WordSection1;}
--></style><div class="WordSection1"><p class="MsoNormal">select * from t order by record_date desc limit 5;<p
class="MsoNormal"> <pclass="MsoNormal">this will return the recent 5 records.. what I want is the oldest 5 records (in
last30 days)</div></blockquote> so remove "desc", in order to have ascending ordering, thus first 5 records are the
fiveoldest:<br /><br /> select * from t order by record_date limit 5<br /><br /> Cheers<br /> Moreno.-<br /><br /><br
/>