Re: newbie question for return date

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