On Tue, 7 May 2002, Randall Perry wrote:
> With the following:
>
> select max(date) from log order by date_time desc limit 12;
>
> The limit clause has no effect on the results; it'll get the latest date
> from the entire record set rather than from the last 12 records.
Maybe something like:
select max(date) from (select date from log order by date_time desc limit
12) c;