From: Stephen Woodbridge
Date: January 8 2001 8:40pm
Subject: Re: 5 last records ?
List-Archive: http://lists.mysql.com/win32/4729
Message-Id: <3A5A25B0.A0F4213F@mediaone.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

How about:

select * from table order by date desc limit 5

-Steve

FL wrote:
> 
> Hi,
> 
> How to build an efficient query to display the 5 last records (order by
> date) ?
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread4728@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-unsubscribe@stripped instead.