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? > >Thx a lot! >Jack >[EMAIL PROTECTED] > > >--------------------------------------------------------------------- >Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before >posting. To request this thread, e-mail [EMAIL PROTECTED] > >To unsubscribe, send a message to the address shown in the >List-Unsubscribe header of this message. If you cannot see it, >e-mail [EMAIL PROTECTED] instead. --------------------------------------------------------------------- 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
