Re: Need last 100 records...

[Dan Nelson]

In the last episode (Jun 25), Mark S Lowe said:
> Is there a nifty way to select just that last 100 records with MySQL? In
> Oracle I use Maxrows and date to accomplish this. Can?t seem to figure this
> out with MySQL. 

You mean "select the 100 most-recently-inserted records" ?

SELECT * FROM table ORDER BY timestampfield DESC LIMIT 100;

-- 
	Dan Nelson
	dnelson@stripped