On Monday 28 Oct 2002 7:57 pm, tviardot wrote:
> Hi guys, here a newbies question.
> I've made a table with some action and date.
> How may i query the most recent date. (I'd like to return only the record
> which have the most recent date ).
SELECT * from table_name ORDER BY date_column DESC LIMIT 1;
If you have an index on date_column this will be almost instant. If two rows
have the same (largest) value in date_column which gets returned isn't well
defined.
--
Richard Huxton