On Thursday 31 January 2002 17:35, Frank Bax wrote:
> select mytable.* from mytable, (select id,max(update) as update from
> mytable group by id) maxes where mytable.id = maxes.id and mytable.update =
> maxes.update;
>
I didn't think of putting the subselect there, I was trying in the where clause.
However, I think using distinct on is probably going to run faster.
Thanks
JohnT