On Mon, Sep 09, 2002 at 00:13:04 +,
Colin Fox <[EMAIL PROTECTED]> wrote:
>
> select
>*
> from
>motm
> order by
>creation_date desc
> limit 1;
>
> So in the first case I select the record that has the largest date. In the
> second case, I order all the records, and then return o
Hi, all.
I'm putting together a small query that should return the most recent
entry from a table by date (I can't use an ID field as new entries may be
added with older dates). It's not crucial that this run at 100%
efficiency, but I'm interested in the results and/or discussion, as this
will pr
