Re: Can this be done in one query?

>
> 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;

Thanks, that did it.

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
Randy Perry
sysTame
Mac Consulting/Sales

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