Re: Can this be done in one query? - Mailing list pgsql-general

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;