I believe that
SELECT * FROM processo_arquivos ORDER BY date DESC LIMIT 10;
Should do it.
Mike Hillyer
-----Original Message-----
From: Felipe Moreno - MAILING LISTS [mailto:ml@stripped]
Sent: Tuesday, December 03, 2002 9:39 AM
To: mysql@stripped
Subject: SQL Select Idea
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 <mysql-thread126423@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-mike=wepsoft.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
