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
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
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