It is a hack, but when someone wants you to do something in a way
different from the norm, aren't they asking for a hack?
SQL Server does something like
select top (1) from ....
I am thinking this is NOT a SQL-99 standard.
-Aaron
On 6/1/06, Yasir Malik <ymalik(at)cs(dot)stevens(dot)edu> wrote:
> > 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