select * from processo_arquivos order by DATE desc limit 10
-Original Message-
From: Felipe Moreno - MAILING LISTS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 12:42 PM
To: [EMAIL PROTECTED]
Subject: MySQL: Select HELP!
Importance: High
Hi List Users,
I want to know
Try this:
SELECT DATE, COD FROM processo_arquivos ORDER BY DATE DESC LIMIT 10
Unfortunately, that puts them in reverse order. There's probably a
better way, with a more sophisticated use of the LIMIT keyword, that
puts them in the right order.
-Alex
On Tuesday, December 3, 2002, at 10:41 AM
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
