SELECT * FROM processo_arquivos ORDER BY DATE DESC LIMIT 0,10
> -----Original Message----- > From: Felipe Moreno - MAILING LISTS [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 03, 2002 1:42 PM > To: [EMAIL PROTECTED] > Subject: MySQL: Select HELP! > Importance: High > > > Hi List Users, > > I want to know if anyone has any idea on how can I do the > SQL command below to archive a result. > I have one table called processo_arquivos that have a > filed called DATE and another FIELD called COD (primary key). > I want to select the last TEN > (10) dates from the Database, but only the last TEN. How Can > I do this? Any ideia? I tried the sql bellow o archive this, > but I was unable to do it. I just want to do this with ONLY > one select, not with two. > > Thanks for any idea. > > Regards, > > Felipe > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php