Hi Jack
select * from TableName order by DateTimeField DESC limit 5
Should do it.
Peter
At 05:04 PM 5/27/2002 +0800, Jack wrote:
Dear all
I had a table which containing (date/time) field, now i want to retrieve 5
most latest update / insert record from that table, what query should i use?
Dear Jack,
If (date/time) field means the last time updated or inserted,
how about this;
select * from [the table] order by (date/time) desc limit 1, 5;
-Original Message-
From: Jack [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 27, 2002 6:05 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]