Re: Am I crazy or is this SQL not possible

From: Yasir Malik <ymalik(at)cs(dot)stevens(dot)edu>
To: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Am I crazy or is this SQL not possible
Date: 2006-06-01 18:53:41
Message-ID: Pine.NEB.4.64.0606011450520.855@pink-elephant.cs.stevens-tech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> select max(date_sent) from table;
> would equal
> select date_sent from broadcast_history order by date_sent DESC limit 1;
>
That sounds like a hack. Is limit a SQL-99 standard? Is there are
another way to do this?
Sorry to take over your topic, Collin.

Thanks,
Yasir

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Florian Weimer 2006-06-01 18:59:05 Re: SELECT DISTINCT too slow
Previous Message Aaron Bono 2006-06-01 18:42:29 Fwd: Stalled post to pgsql-sql