From: Steve Ruby
Date: January 8 2001 8:47pm
Subject: Re: 5 last records ?
List-Archive: http://lists.mysql.com/win32/4730
Message-Id: <3A5A277D.2D85863D@rubysolutions.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

FL wrote:
> 
> Hi,
> 
> How to build an efficient query to display the 5 last records (order by
> date) ?


You can only display the "last" 5 ordered by date ASCENDING if you know
the total number of rows, otherwise you can cheat by sorting DESCENDING
and viewing the first 5..

select * from <tablename> order by <datecolumn> desc limit 5;