Can this be done in one query?

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.

It works if I do this:
create temp table as select date from log order by dat_time desc limit
12;

select max(date) from temp;

So, is there a way to do this in one query without creating a temp table?

--
Randy Perry
sysTame
Mac Consulting/Sales

phn 772.589.6449
mobile email help(at)systame(dot)com